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

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

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