| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using array with Windows().activate
If it isn't one thing its another. This generates type mismatch error on the
last line. Am I doing something stupid again or, if I can't do it this way, can someone suggest a better way? Thanks! Sub ImaNoob() Dim MyFiles, I As Variant MyFiles = Array("Con.xls", "CAN1a.xls", _ "CAN1b.xls", "CAN1c.xls") For Each I In MyFiles Application.Windows(MyFiles(I)).Activate ....do some stuff Next I End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cannot open exel from windows xp in windows vista and visa versa | New Users to Excel | |||
| can windows vista edit shared document from windows xp | Excel Worksheet Functions | |||
| Page breaks are different in Windows 2000 and Windows XP | Excel Discussion (Misc queries) | |||
| How to activate array formulas in a range of cells all at the same time? | Excel Programming | |||
| Use Array to activate workbooks | Excel Programming | |||
Threaded Mode
