Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
All open workbooks
How do I determine all the currently open workbooks?
I will be writing a macro that will copy certain information from on workbook and paste it into the other workbook. The user will determine - based on open workbooks - which workbook t copy from - and which workbook to copy into. Thanks for any assistance -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
All open workbooks
Dim wbk as WorkBook
For each wbk In WorksBooks MsgBox wbk.Name Next wbk -----Original Message----- How do I determine all the currently open workbooks? I will be writing a macro that will copy certain information from one workbook and paste it into the other workbook. The user will determine - based on open workbooks - which workbook to copy from - and which workbook to copy into. Thanks for any assistance! --- Message posted from http://www.ExcelForum.com/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbooks Don't Open | Setting up and Configuration of Excel | |||
when i open an Excell file 3 workbooks open.Why? | Excel Discussion (Misc queries) | |||
When I open Excel, workbooks open automatically. How can I stop t | Excel Discussion (Misc queries) | |||
Workbooks.Open closes other workbooks | Excel Programming | |||
Workbooks.Open / .Open Text - How do you stop the .xls addition? | Excel Programming |