Activate workbook syntax?

[hadamhiram]

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!

[AB33]

Please Login or Register  to view this content.

[Arkadi]

Please Login or Register  to view this content.

[hadamhiram]

Thank you, this works!

[hadamhiram]

Thank you, this works too!