ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Question about FileDialog (https://www.excelbanter.com/excel-programming/444443-question-about-filedialog.html)

Robert Crandal[_2_]

Question about FileDialog
 
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[_2_]

Question about FileDialog
 
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.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc



Robert Crandal[_2_]

Question about FileDialog
 
Thanks yet again for you help Mr. GS!


"GS" wrote in message ...

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.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc



GS[_2_]

Question about FileDialog
 
Robert Crandal explained on 4/14/2011 :
Thanks yet again for you help Mr. GS!


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

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc




All times are GMT +1. The time now is 04:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com