I have been tasked with updating multiple workbooks with the same information. I have created a macro to do so upon opening of an individual workbook which works well, but is there a way to modify the existing macro to loop through the other workbooks in other folders and perform the same action? I understand I would have to change the "on open function" and run it manually. The original basic macro I created is as follows;

Please Login or Register  to view this content.
Please understand I am a very new user and am learning as I go!

I appreciate any assistance or suggestion