Question about FileDialog

[Robert Crandal]

I am currently using Application.FileDialog(4) to display
a system dialog box that allows the user to select a
folder. Is there any way to setup this function so it
initially opens at a folder of my choosing? This dialog
seems to always begin at the "MyDocuments" folder
and I would like to be able to change this. Let me know
if this is possible.

Thank you!

Robert Crandal

 

[GS]

Robert Crandal wrote on 4/14/2011 :

I am currently using Application.FileDialog(4) to display
a system dialog box that allows the user to select a
folder. Is there any way to setup this function so it
initially opens at a folder of my choosing? This dialog
seems to always begin at the "MyDocuments" folder
and I would like to be able to change this. Let me know
if this is possible.

Thank you!

Robert Crandal

Robert,
Check out the "InitialFilename" property in the online help. (Click in
the word "FileDialog" and press F1)

You can specify where the dialog opens, as well as other things for
many of the different dialogs.

 

[Robert Crandal]

Thanks yet again for you help Mr. GS!

 

[GS]

Robert Crandal explained on 4/14/2011 :

Thanks yet again for you help Mr. GS!

You're welcome, Robert! Glad to be of help...