Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting current directory
Hello all,
I can set the current directory using the following myCurrentFolder = ActiveWorkbook.Path ChDir myCurrentFolder this works great for my 'file choser' dialog box on my local drive c: the problem occurs for a mapped network drive... using the same line of code and running the macro from a mapped network drive it sets my dialog window to my documents. does anyone know why this is the case? or any direction to solve this? regards, jerm |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
current directory | Excel Discussion (Misc queries) | |||
Current Directory | Excel Discussion (Misc queries) | |||
get current directory | Excel Programming | |||
How to force current directory | Excel Programming | |||
changing current directory to that of the current open file | Excel Programming |