What is brest way to flit between two spreadsheets

  • Thread starter Thread starter Angus Comber
  • Start date Start date
A

Angus Comber

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
(e-mail address removed)
 
Sorry for being a berk!

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

Angus
 
Back
Top