Changing to different drive and directory
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)
"Rob" wrote in message
...
Thanks Bob,
I'll try that when I can next week, but I hope it works (see post from
Francois).
Rob
"Bob Phillips" wrote in message
...
Do both
ChDrive "H"
ChDir "H:\Accounting\Journals"
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Rob" <none wrote in message
...
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
|