![]() |
Default File Path
Hi Simon
May be keeping trace of Thisworkbook.Path with a variable in your macro would fit your needs: Dim OriginalPath$ OriginalPath = ThisWorkbook.Path 'Do dome stuff here 'reset path to the original (thisworkbook's) ChDir(OriginalPath) HTH Cordially Pascal "Simon Shaw" a écrit dans le message de ... 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 08:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com