Collect Modules into one workbook

[Pops Jackson]

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,

 

[Barb Reinhardt]

This should get you started. What would you do if the same module was in
multiple workbooks?

http://www.cpearson.com/excel/vbe.aspx

 

[Pops Jackson]

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