Application.FileDialog

  • Thread starter Thread starter Edward Harford
  • Start date Start date
E

Edward Harford

Northwind sample in Form_Emloyees works fine.
My own same code in another mdb file comes up:

Run-time error -
Method 'FileDialog' of object'_Application' failed

on line:
With Application.FileDialog(msoFileDialogFilePicker)

With thanks
edwardh
 
The FileDialog object works only if you include a reference to the Office
library.

Open a code window.
Choose References from the Tools menu.
Check the box beside "Microsoft Office ..." for your version.
 
Back
Top