Application.filedialog--- default directory

[Guest]

I'm using the application.filedialog method to get a file. I want to set the
default directory where this dialog opens up... any ideas??

(*** I tried
chdrive "C:"
then
chdir "C:\whatever")

didn't seem to work

 

[David Lloyd]

Tom:

One approach is to use the InitialFileName property of the FileDialog object
and set it equal to the directory without specifying an actual filename.
For example:

Dim fd As FileDialog

Set fd = Application.FileDialog(msoFileDialogFilePicker)

fd.InitialFileName = "h:\Program Files"
fd.Show

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I'm using the application.filedialog method to get a file. I want to set
the
default directory where this dialog opens up... any ideas??

(*** I tried
chdrive "C:"
then
chdir "C:\whatever")

didn't seem to work

 

[Douglas J. Steele]

Far better is to use APIs. See http://www.mvps.org/access/api/api0001.htm
for a complete example.