Default File Path
Dim sPath as String
' store the current path in a variable sPath = Curdir ' code to change path chdrive sPath chdir sPath -- Regards, Tom Ogilvy "Simon Shaw" wrote in message ... How do I reset the default file path? My macro saves a text file out to a network path. But after the macro is run, when i go to open another file, the default path is the network path were the macro saved the file. How to I set the default path back to the path prior to running my macro? |
All times are GMT +1. The time now is 04:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com