ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to assign directory for GetOpenFilename method (https://www.excelbanter.com/excel-programming/284943-how-assign-directory-getopenfilename-method.html)

Tim_M

How to assign directory for GetOpenFilename method
 
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?

Vasant Nanavati

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?




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

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