| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capturing current folder path
When clicking on the OPEN dialog box, .xls displays the current "folder
path". How do I programatically capture this current path. My objective is following: programatically I will be changing the folder from where to pick up files and save files. However, when I quit the macro I would like to reset the folder to the original setting before I started the macro. Hence I would like to capture the current folder space so that I can revert back to it at the end. Many thanks in anticipation of your reply. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Capturing current folder path
Check out CurDir.
NickHK "DKS" wrote in message ... When clicking on the OPEN dialog box, .xls displays the current "folder path". How do I programatically capture this current path. My objective is following: programatically I will be changing the folder from where to pick up files and save files. However, when I quit the macro I would like to reset the folder to the original setting before I started the macro. Hence I would like to capture the current folder space so that I can revert back to it at the end. Many thanks in anticipation of your reply. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Capturing current folder path
Thanks.
"NickHK" wrote: Check out CurDir. NickHK "DKS" wrote in message ... When clicking on the OPEN dialog box, .xls displays the current "folder path". How do I programatically capture this current path. My objective is following: programatically I will be changing the folder from where to pick up files and save files. However, when I quit the macro I would like to reset the folder to the original setting before I started the macro. Hence I would like to capture the current folder space so that I can revert back to it at the end. Many thanks in anticipation of your reply. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reference to current file path/folder name? | Excel Programming | |||
| Capturing a file path | Excel Programming | |||
| Capturing a file path | Excel Programming | |||
| Help : Macro for capturing current system time | Excel Programming | |||
| On Error, Capturing current module and actual line of code | Excel Programming | |||
Linear Mode
