You can access an open document by using the following code:
Windows("Book2.xls").Activate ' Activate a document
Sheets("Sheet2").Select ' Select the proper sheet in that document

Stephane.