How set file open path to filepath of file opened with Explorer ?
I frequently open Excel files from Windows Explorer. Then I need other files
that are in that files directory. What VBA command will set file open path ? I could not get application.defaultfilepath = .... to work, if that is the right command to use. I am using File open event, I also add the file to the recents list. Using Excel 2000. Thanks. |
All times are GMT +1. The time now is 06:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com