Sorry, I have almost no knowledge of VBA!
I'm trying to switch between workbooks whose names are variable. I can get the syntax for activating a workbook with a specific name correct, but I can't get it to work by referring to the workbook variable...
My code:
Set InputWbk = ActiveWorkbook
Workbooks("Output.xlsx").Worksheets("Sheet1").Activate ' Works fine because the full file name is there
Workbooks(InputWbk).Worksheets("Sheet1").Activate ' Not working...
This should be very simple but my hunt for the correct syntax on Google is not turning up anything - everything I can find works exclusively with specific file names.
Thanks in advance for your help!
Bookmarks