Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA - Help looping through all but 2 workbooks
I need to loop through all workbooks except two that I specify. I hav
the code to loop through all workbooks except the workbook containin the code but I cannot modify the code to include a second workbook th code should skip. Sub test() Dim wb As Workbook Application.DisplayAlerts = False 'Loop through each open workbook For Each wb In Workbooks If Not (wb.Name = ThisWorkbook.Name) Then wb.Activate Range("H10") = "CHECK" End If Next wb End Sub I tried replacing the If statement with: If Not (wb.Name = ThisWorkbook.Name) Or (wb.Name = "test.xls" Then ....with no luck. Thanks for any assistance -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA - Help looping through all but 2 workbooks
Try
If (wb.Name < ThisWorkbook.Name) And (wb.Name < "test.xls") Then -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "waveracerr " wrote in message ... I need to loop through all workbooks except two that I specify. I have the code to loop through all workbooks except the workbook containing the code but I cannot modify the code to include a second workbook the code should skip. Sub test() Dim wb As Workbook Application.DisplayAlerts = False 'Loop through each open workbook For Each wb In Workbooks If Not (wb.Name = ThisWorkbook.Name) Then wb.Activate Range("H10") = "CHECK" End If Next wb End Sub I tried replacing the If statement with: If Not (wb.Name = ThisWorkbook.Name) Or (wb.Name = "test.xls") Then ...with no luck. Thanks for any assistance! --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looping through 2 workbooks | Excel Discussion (Misc queries) | |||
Looping through all workbooks | Excel Programming | |||
Looping through all workbooks | Excel Programming | |||
Looping through all workbooks | Excel Programming | |||
VBA code for looping through open workbooks and worksheets | Excel Programming |