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