View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
papou[_9_] papou[_9_] is offline
external usenet poster
 
Posts: 52
Default 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?