Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
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 path for pictures | Excel Discussion (Misc queries) | |||
Make "BeforeSave" event supply a default path and file name? | Excel Programming |