| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Execute VB code against certain open workbooks
I have a 'Master' file that contains code in which I need to access other
open files and perform a subset of code against each of them. The possible number of open files is anywhere from 1 to 12---and each of the files will be named sequentially Book1, Book2, Book3, etc. as they will have been generated from a previous 'Copy Sheet' process performed by the user. How can I write my code such that it identifies the number of these "Books" that are open, then loops through each of them (performing the addt'l code), then stopping when it reaches the last open book? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Wildcard in workbooks open code | Excel Programming | |||
| vba code to open workbooks | Excel Worksheet Functions | |||
| macro or code to open multiple workbooks | Excel Discussion (Misc queries) | |||
| Using a Variable in the Workbooks.Open code | Excel Programming | |||
| Using a Variable in the Workbooks.Open code | Excel Programming | |||
Threaded Mode
