Automatically select another open spreadsheet

[ajocius]

Gentlemen,
I have two spreadsheets that are open and each are from its own separate file or workbook. I'm using Excel 2007 and attempting to switch between one open to the other open. How do I do this using VBA? Thank you in advance and have a Happy New Year.

[ajocius]

Oh, I forgot. The workbook names are never the same.

[royUK]

You can refer to the workbook containing the code as ThisWorkBook.

You don't actually need to activate the workbooks in your code.