Merging seperate workbooks into one workbook

Hi,

I am looking to merge a bunch of workbooks with one sheet in each of them
into a single workbook with a bunch of sheets. All of the files are in the
same folder. Once upon I time I downloaded a utility from microsoft.com that
did this in a snap, but I cannot find it. Does anyone know where I can find
that utility or how I can do this?

Much thanks,

Raoul Duke

Hi Raoul

Start here
http://www.rondebruin.nl/copy3.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Raoul Duke" <[email protected]> wrote in message news:[email protected]...
> Hi,
>
> I am looking to merge a bunch of workbooks with one sheet in each of them
> into a single workbook with a bunch of sheets. All of the files are in the
> same folder. Once upon I time I downloaded a utility from microsoft.com that
> did this in a snap, but I cannot find it. Does anyone know where I can find
> that utility or how I can do this?
>
> Much thanks,
>
> Raoul Duke

I found what I was looking for. There is an Excel 97 addin called
consolid.xla which is installed from consolid.exe. Run a search on
microsoft.com for consolid.exe if you need it. It works on Excel 2000 and
2003.

"Raoul Duke" wrote:

> Hi,
>
> I am looking to merge a bunch of workbooks with one sheet in each of them
> into a single workbook with a bunch of sheets. All of the files are in the
> same folder. Once upon I time I downloaded a utility from microsoft.com that
> did this in a snap, but I cannot find it. Does anyone know where I can find
> that utility or how I can do this?
>
> Much thanks,
>
> Raoul Duke