Changing to different drive and directory

R

Rob

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
 
B

Bob Phillips

Do both

ChDrive "H"
ChDir "H:\Accounting\Journals"


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
F

Francois via OfficeKB.com

Bob said:
Do both

ChDrive "H"
ChDir "H:\Accounting\Journals"
Hi,
Click to expand...
[quoted text clipped - 10 lines]
Rob
Click to expand...
Click to expand...

Sorry to hijack this thread, I've tried this on a task that I have (to print
through adobe accrobat to a specific directory as a PDF file), but the
directory hasn't changed, It's still one that I accessed previously
Any suggestions
 
R

Rob

Thanks Bob,

I'll try that when I can next week, but I hope it works (see post from
Francois).

Rob
 
B

Bob Phillips

I haven't come across a problem, and I never use PDF, so no ideas there.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
R

Rob

Hi Bob,

Just to let you know adding ChDrive "H" to the procedure worked for me.

Thanks again,

Rob
 
Top