I send out an excel file to about 150 locations that contains a macro for
posting bonus information to a second excel file. Because I cannot control
the location where this second file is placed, I currently have the user
"search" (just like when you open or save as a file) for the file when the
macro is started.
What I would prefer to do is have the user search for the file the first
time, and once they find it and click on the file to open, have the macro
save the path so that in the future, the macro will automatically know where
to find the file and open it without the user having to do anything.
Of course, I will need something should the user move the file or need to
change the file (it will change annually) that will ask if they want to
search for another file and make it the default file.
Any help would be appreciated!