What is brest way to flit between two spreadsheets
 

Hello

I have a sheet1.xls and a sheet2.xls - they are both currently open.

If I want to refer to one spreadsheet file I can use
Excel.Workbooks(indexnumber) but can I do the same using a variable filename
string.

For example I want to do something like

A) Refer to sheet1.xls

Worksbooks.Attach strFirstSheet


B) Refer to sheet2.xls
Workbooks.Attach strSecondSheet

How can I do this?

Angus Comber

What is brest way to flit between two spreadsheets
 

Sorry for being a berk!

I can use Excel.Workbooks(strFile).activate or whatever

Angus

"Angus Comber" wrote in message
...
Hello

I have a sheet1.xls and a sheet2.xls - they are both currently open.

If I want to refer to one spreadsheet file I can use
Excel.Workbooks(indexnumber) but can I do the same using a variable
filename
string.

For example I want to do something like

A) Refer to sheet1.xls

Worksbooks.Attach strFirstSheet


B) Refer to sheet2.xls
Workbooks.Attach strSecondSheet

How can I do this?

Angus Comber