Macro to Open Up Workbooks

I was wondering if someone could help me out with the context of a Macro. I have a workbook with a summary page that references various other workbooks. On the other workbooks there are values that need to be updated everyday. Unfortunately to only way to do that is to open up that actual workbook.... Therefore, I would like to write a macro so when my summary page workbook is opened up, it opens up all the other workbooks its referencing. The code doesnt have to say : when summary workbook is opened, open all workbooks that are being referenced" because i feel like that would be way more difficult. In the macro i can just list the workbooks that need to be opened. Let me know if someone could help me out with the language.

-Jake

put this in the "ThisWorkbook" object code:

Please Login or Register  to view this content.

edit with correct name and range