By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,222 Members | 1,129 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,222 IT Pros & Developers. It's quick & easy.

Open File in other folder

P: n/a
(Access 2000)

I have:

Set eWB = e.Workbooks.Open("Book1.xls")

Where e is DIM'd as an Excel.Application and eWB as an Excel.Workbook.

This file opens fine.

This file is in folder "ThisFolder" along with the .mdb file.

Now, my question concerns, how do I get a file that is in a folder one
up, such as "UpperFolder" is the name of the folder that contains
"ThisFolder" and "Book2.xls" is in "UpperFolder".

Thanks.

- Bruce

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
how about passing the full path to the file?
Nov 12 '05 #2

P: n/a
> Set eWB = e.Workbooks.Open("Book1.xls")
[...]
This file opens fine.


Are you sure? I have to provide the full path like
"C:\ThisFolder\Book1.xls", otherwise it won't work, even with a
ChDir "C:\ThisFolder\" before.

Peter

--
No mails please.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.