Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbooks Array
Excel XP & Win XP
I want to work with a group of workbooks, one at a time. I wanted to use the following statement but I get a "Type Mismatch" error on the "For Each..." line. All the workbooks are open. My code, simplified, is: Dim wbOther as Workbook For Each wbOther In Workbooks(Array("One.xls", "Two.xls", "Three.xls")) MsgBox wbOther.Name Next wbOther How can I setup a "For" loop for a group of workbooks? Thanks for your time. Otto |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create an array of all open workbooks | Excel Programming | |||
Opening Workbooks / Filling Array | Excel Programming | |||
SOS-How to pass array parameter to Workbooks.OpenText(...) in VC++ | Excel Programming | |||
Array Sheets Copy to new Workbooks | Excel Programming | |||
Use Array to activate workbooks | Excel Programming |