D
dim
Hi,
I have a problem using the code below:
Workbooks.Open ThisWorkbook.Path & "\Data\Book2.xls"
Im trying to use the above command within Book2.xls. The file and path is:
C:\Program Files\MyProgram\Data\Book2.xls
But I want to open the following:
C:\Program Files\MyProgram\Data1\Book3.xls
When I use:
Workbooks.Open ThisWorkbook.Path & "\Data1\Book3.xls"
Im told that the path C:\Program Files\MyProgram\Data\Data1\Book3.xls could
not be found.
How can I determine the path, then remove the last folder section from it
before adding in the new folder and file to open?....Is this possible?
I Need Help! :drowning:
I have a problem using the code below:
Workbooks.Open ThisWorkbook.Path & "\Data\Book2.xls"
Im trying to use the above command within Book2.xls. The file and path is:
C:\Program Files\MyProgram\Data\Book2.xls
But I want to open the following:
C:\Program Files\MyProgram\Data1\Book3.xls
When I use:
Workbooks.Open ThisWorkbook.Path & "\Data1\Book3.xls"
Im told that the path C:\Program Files\MyProgram\Data\Data1\Book3.xls could
not be found.
How can I determine the path, then remove the last folder section from it
before adding in the new folder and file to open?....Is this possible?
I Need Help! :drowning: