Application.FileDialog

[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

 

[Allen Browne]

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.