E
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.
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.