Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing to different drive and directory
Hi,
I'm trying to run some code and part of that is to change to a particular drive, directory and folder. Namely: ChDir "H:\Accounting\Journals" However, I find that the excel code ignores this instruction and saves the text file (created via the code) to whatever directory I may have opened last. As I am on a network, is there something else that needs to be included in the code to force Excel to go to the correct drive, etc.? Rob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Link References Change to Startup Directory | Links and Linking in Excel | |||
Target directory & Path | Excel Worksheet Functions | |||
auto file path update when excel sheet moved to another directory. | Excel Discussion (Misc queries) | |||
Drive - Folders - Files | Excel Discussion (Misc queries) | |||
How do I insert the directory path in my Excel file? | Excel Worksheet Functions |