I currently have 5 very similar but seperate macros in 5 seperate .xls files. As one finishes I currently open the next .xls file and run that respective macro. And so on and so forth.
I am attempting to figure out how I can write code that will require me to only manually run the first macro to complete the first file and then somehow either access or open the next file and run the next macro in the series automatically. And so on and so forth.
To complicate matters slightly, each of the .xls files currently is refreshed by an external database query that is automatically executed when the file is first opened.