Long story short. we have about 10 teams that were running a template that had macros embedded in the files. I'm trying to see if its possible... if i had a list of the 10 file locations, go down that list, open the file and then run said macros associated with each opened file. before I dig any deeper into this, is this even a possibility?
I have attempted setting the new opened file as a new workbook(WB2) and then trying to run macros based out of that workbook.
process from main excel file
I have attempted setting the new opened file as a new workbook(WB2) and then trying to run macros based out of that workbook.
process from main excel file
- run macro button
- opens first file on list (wb2)
- runs said macro from first opened workbook (wb2)
- closes wb2
- loops 2-4
