Hi
I'm new to excel land self taught, I'm having trouble with a Macro I wish to create which will extract the file path from the active workbook and use this file path to open a new file with a predetermined name that sits in the same directory.
The code works fine when I manually enter the file directory but I wish to obtain the file directory from the active work books location.Please Login or Register to view this content.
Bookmarks