D
dim
Hi folks, I'm really hoping someone can help me with this question, it has
two parts.
I have a folder called 'MyProgram', and within it I have a folder called
'Data'. In the MyProgram folder I have the currently active workbook,
'Book1.xls', and in the Data folder I have 'Book2.xls'.
Firstly I need to locate where the currently active workbook Book1.xls is on
the current hard drive? e.g: C:\Program Files\MyFolder...or D:\Example\The
Program\MyFolder etc
Then I need to adapt and use this information in a Workbooks.Open statement
to open Book2.xls in the Data subfolder?
Any help is much appreciated.
two parts.
I have a folder called 'MyProgram', and within it I have a folder called
'Data'. In the MyProgram folder I have the currently active workbook,
'Book1.xls', and in the Data folder I have 'Book2.xls'.
Firstly I need to locate where the currently active workbook Book1.xls is on
the current hard drive? e.g: C:\Program Files\MyFolder...or D:\Example\The
Program\MyFolder etc
Then I need to adapt and use this information in a Workbooks.Open statement
to open Book2.xls in the Data subfolder?
Any help is much appreciated.