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" wrote in message ...
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