Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop through all open workbooks except Personal.xls
Hello,
I'm really inexperienced in VBA and I need to execute a sub procedure in all open workbooks except in Personal.xls, but I'm having trouble coding this. What am I doing Wrong? Or maybe there's an easier way to do this Here it is what I have: Sub nome_cenario() Dim wkb As Workbook For Each wkb In Workbooks If wkb.name = "PERSONAL.xls" Then Next wkb Else Call Myprocedure Next wkb End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Personal macros not available when workbooks.open | Excel Programming | |||
Window_Open in personal.xls run each time I open subsequent workbooks. | Excel Programming | |||
Loop Through All Open Workbooks | Excel Programming | |||
Loop through all Open workbooks | Excel Programming | |||
Loop through open workbooks | Excel Programming |