I'm working on a project that is using VBA code and it is saved as an XLTM So that multiple people can open and use at same time and since this project is going to be used by other divisions and not knowing where they will place this file and the other that are needed to used I need to refer back to the original File folder to open other Files used with in the project
this is what I used and works if i have the XLTM file its self open
Set wbBook1 = ActiveWorkbook
MasterPath = wbBook1.Path
But when i Double click and open the new file is opened with out referring back to the original path its just empty which make sense
so is there a way to either get the original path as the file is opening or some way to get it with out having the person going back and selecting it with the out using File Dialog Folder Picker?
this is what I used and works if i have the XLTM file its self open
Set wbBook1 = ActiveWorkbook
MasterPath = wbBook1.Path
But when i Double click and open the new file is opened with out referring back to the original path its just empty which make sense
so is there a way to either get the original path as the file is opening or some way to get it with out having the person going back and selecting it with the out using File Dialog Folder Picker?