View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default 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