I have a main workbook where the file name is likely to change.
There is a load macro which opens a another specific xlsx and transfers data into the main xlsx.
When I created the load routine it keeps the name of the main xlsx in the code. When the name of the main xlsx changes the code will obviously fail (as the name of the main xlsx has been changed).
It's more of a structure question, but can anyone suggest a way round this?
Many thanks
Andrew
Bookmarks