| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spreadsheets | Excel Discussion (Misc queries) | |||
| Spreadsheets | Excel Worksheet Functions | |||
| Can Excel Spreadsheets be saved as Microsoft Works spreadsheets? | Excel Discussion (Misc queries) | |||
| SPREADSHEETS | Setting up and Configuration of Excel | |||
| spreadsheets | Charts and Charting in Excel | |||
![Angus Comber[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
