How to make a different workbook Active vba

[smichael]

I'm trying to run a script that will close a workbook that is currently not active. Is there a way to make a different workbook the active one so that i could say:

ActiveWorkbook.Close  True

or is there another way to do this?

Any help would be greatly appreciated!

 

[VoG]

Try referring to it explicitly

Workbooks("test.xls").Close True