Jeff Meyers
Active Member
- Joined
- Mar 14, 2012
- Messages
- 405
I am trying to have several linked / supportive workbook files open when a user opens a summary workbook file. I have used the macro recorder to get started and have this snippet:
If I have the referenced filename in my summary workbook in cell B19 on Sheet 2, how would I change the above code to utilize it?
And if I have the file directory / path in another cell in Sheet 2, how could I reference that in the VBA code?
Thanks!
Code:
ChDir "I:\FY11-12 Budget\Budget Projections\4th Qtr"
Workbooks.Open Filename:="FY11-12 Projections - 2012-03-31 - ADRC.xlsm"
And if I have the file directory / path in another cell in Sheet 2, how could I reference that in the VBA code?
Thanks!