VB Code not changing directory (Excel 2003)

Topic

New Reply

I have the following code:
ChDir “C:dds_txt”
Workbooks.Open “Email List.xls”, , N, , , , Y

When I am located any where on the network, this seems to work – except when I am logged into my personal drive (H:/). In this case, the change doesn’t work and I get the error “Email List.xls Not Found”. Is there something I should add to the “CHDIR” command so it works from other drives?

Reply | Quote

Replies

You can use

Workbooks.Open “C:dds_txtEmail List.xls”

Or use

ChDrive “C:”
ChDir “C:dds_txt”
Workbooks.Open “Email List.xls”

Reply | Quote

Many thanks. So you know, I got an email from someone that said, “I have decided that Hans is not just one person.” I don’t know if you are (I can easily believe that there must be more than 1 of you), but whoever you are, I am always grateful. Thanks.

Reply | Quote

There’s just one of me…

Reply | Quote

The username is a dead giveaway – HansI, HansII, HansIII and HansIV all do the research behind the scenes!

Reply | Quote

Now, now…

HansVI

Reply | Quote

Nice!

Reply | Quote

Good one Hans

Reply | Quote