Hi All,
Is there a way to make the contents of a particular cell in a worksheet show where to pick up another file. Here is my code to pick up a file:
Then, I need to be able to pickup the path and drive from a cell out of a particular worksheet so I user can change it when they move the project around.
Lets say I want to put the drive and path under A1 and A2 in workbook named KittyCat where a user can go in and change it. How would I alter the code above to make it accept this. Thank you for any help you can provide on this!!!
Bookmarks