Application.FileDialog

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
 
A

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