View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default How to assign directory for GetOpenFilename method

I don't believe there is an easy way to have the filename appear in the
textbox. For the directory, you probably need to use (ChDrive and) ChDir to
change the "current" directory.

--

Vasant

"Tim_M" wrote in message
...
How would I assign a directory in code to first appear after the

GetOpenFilename is used? Also is there any way to have the filename
selected in that dialog box to appear in the text box?