VBA: Activate Window with Cell Reference

[adberg]

Hi again,

So I have to activate a workbook, but the workbook name must be dynamic in the VBA. I am trying to make it reference a specific cell but I keep getting an error. Currently I have this setup:

Windows("2H12 Training Workbook.xlsm").Activate

But, I want the 2H12 to reference a cell. I have tried this with no luck:

Windows("(Sheets("Input").Range("A1").Value) & " Training Workbook.xlsm").Activate

Any suggestions?

 

[kpark91]

In order to activate it, you must have the file first opened.
Maybe that's the problem?

What is the error message you're getting?

 

[adberg]

In order to activate it, you must have the file first opened.
Maybe that's the problem?

What is the error message you're getting?

Yes the window is already opened. It switches back and forth between mutilple windows multiple times.