Thread: What is brest way to flit between two spreadsheets
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Angus Comber[_2_] Angus Comber[_2_] is offline
external usenet poster
  
Posts: 15
Default 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




Reply With QuoteReply With Quote