FileDialog Widget

[Ed Warren]

How do I open a file dialog object in VBA. I searched the MS Knowledge base
and found the following code, however, it fails:

Error: "Undefined user object" on the line that creates the variable fd. I
have referenced the Access 11.0 library.

'Declare a variable as a FileDialog object.
Dim fd As FileDialog
'Create a FileDialog object as a File Picker dialog box.
Set fd = Application.FileDialog(msoFileDialogFilePicker)


So I'm missing something very, very basic here.

Thanks,

Ed Warren.

 

[Douglas J. Steele]

I believe the FileDialog object is in the Office 11.0 library, not the
Access 11.0 library.

However, do yourself a favour and scrap the FileDialog object. Use the
all-API approach shown in http://www.mvps.org/access/api/api0001.htm at "The
Access Web". Far less problematic.

 

[Ed Warren]

Thanks for the link, I will take a loook at it.

Ed Warren