| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop through workbooks and worksheets in each workbook
Hi:
I am looking for a code sample that will loop through all excel workbooks and all of worksheets within each of the workbooks. Can someone please provide some insight into how to accomplish this? Thanks, Eric |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Loop through workbooks and worksheets in each workbook
this is the basic idea.
for each wb in workbooks for each ws in worksheets do thing next ws next wb -- Don Guillett SalesAid Software wrote in message oups.com... Hi: I am looking for a code sample that will loop through all excel workbooks and all of worksheets within each of the workbooks. Can someone please provide some insight into how to accomplish this? Thanks, Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy worksheets from several workbooks into one workbook | Links and Linking in Excel | |||
| Detach different WORKSHEETS in one WORKBOOK into DIFFERENT WORKBOOKS | Excel Worksheet Functions | |||
| 2 Workbooks and 6 Worksheets - Need to Populate 1 Workbook | Excel Worksheet Functions | |||
| Include Worksheets From Workbooks into ONE new Workbook | Excel Programming | |||
| Copying Several Workbooks into one Workbook as Worksheets | New Users to Excel | |||
Linear Mode
