Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to print file path in footer as default option for all files? | Excel Worksheet Functions | |||
Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
Setiiing up file name & path as a default setting on all sheets/ta | Excel Discussion (Misc queries) | |||
Default File Path | Excel Programming | |||
Make "BeforeSave" event supply a default path and file name? | Excel Programming |