FileDialog DataType not defined

Although I'm relatively new to Access VBA, I've done a lot of macro programming in Excel VBA. The problem I'm having is that I get a 'User Type not defined' error at this line -

Dim fd As FileDialog

I'm currently running Access 2003.
My objective is to select a file in a directory and extract information (mainly path but also some info from the filename) and then make file names based on that selection for importing into Access.

Sub AutoImport()
Dim FileTitle, ErrorMsg, BasePath, SystemName As String
Dim fd As FileDialog
Set fd = Application.FileDialog(msoFileDialogFilePicker)
.
.
.
End Sub

re: FileDialog DataType not defined

As far as I can see there is no variable type of 'FileDialog' in the main Access libraries.
Is this something you were used to using in Excel?

re: FileDialog DataType not defined

The FileDialog is only available from Office XP versions and maybe later. Is your version older than this?

re: FileDialog DataType not defined

BTW, if you do have an office xp or later version you may just need to create a reference to the library.

Go to Tools - References and look for Microsoft Office 10 Library or later version.