FileDialog

[dirk van waes]

Hello,
When I use
Dim fd As FileDialog
I get the user-defined/not defined error. What am I doing wrong or what do I
forget?
I'm using access 2003
Thxs
Dirk

 

[Stefan Hoffmann]

hi Dirk,

When I use
Dim fd As FileDialog
I get the user-defined/not defined error. What am I doing wrong or what do I
forget?
I'm using access 2003

You have to set a reference to the Microsoft Office 11 Library (Dim fd
As Office.FileDialog), otherwise you can use Application.FileDialog.


mfG
--> stefan <--

 

[Allen Browne]

Dirk, can I suggest you use the API call instead of the FileDialog object:
http://www.mvps.org/access/api/api0001.htm

As Stefan pointed out, FileDialog requires another reference (increased
chance of a bad reference). It does not work in the runtime version. And it
does not work at all for SaveAs, even though it appears to offer that
option.