Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 158
Default 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



  #2   Report Post  
Posted to microsoft.public.excel.programming
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


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 158
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
FileDialog Question LeAnn Excel Programming 6 November 3rd 07 11:41 AM
FileDialog question LeAnn Excel Programming 4 September 11th 07 10:42 PM
FileDialog Box Question Paul Excel Programming 0 May 8th 06 02:00 PM
FileDialog Jag Man Excel Programming 3 February 2nd 04 04:50 AM


All times are GMT +1. The time now is 06:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"