| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Collect Modules into one workbook
I know this has been discussed in the past but I cannot find the thread
despite much searching. I need to construct my procedure to go into all the Excel files on my hard drive and copy all the modules into one workbook. Can anyone direct me to that discussion or to the necessary code? Thanks, -- Pops Jackson |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Collect Modules into one workbook
This should get you started. What would you do if the same module was in
multiple workbooks? http://www.cpearson.com/excel/vbe.aspx -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "Pops Jackson" wrote: I know this has been discussed in the past but I cannot find the thread despite much searching. I need to construct my procedure to go into all the Excel files on my hard drive and copy all the modules into one workbook. Can anyone direct me to that discussion or to the necessary code? Thanks, -- Pops Jackson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Collect Modules into one workbook
Thanks, Barb. This is exactly what I needed. I will have some weeding out
to do in the case of duplicates but that will be no problem. Jim -- Pops Jackson "Barb Reinhardt" wrote: This should get you started. What would you do if the same module was in multiple workbooks? http://www.cpearson.com/excel/vbe.aspx -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "Pops Jackson" wrote: I know this has been discussed in the past but I cannot find the thread despite much searching. I need to construct my procedure to go into all the Excel files on my hard drive and copy all the modules into one workbook. Can anyone direct me to that discussion or to the necessary code? Thanks, -- Pops Jackson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can collect data from multiple sheets in the same workbook? | Excel Discussion (Misc queries) | |||
| copying modules from one workbook to another workbook | Excel Discussion (Misc queries) | |||
| Multiple Modules in the same workbook? | Excel Programming | |||
| Automatically Delete WorkBook 2 modules by using Workbook 1 module | Excel Programming | |||
| Copy Modules from One workbook to Active Workbook | Excel Programming | |||
Hybrid Mode
