Automatically compiling many workbooks into one
 

I'm needing to copy a bunch of information from a bunch of different excel
files into one massive workbook. I'm hoping to avoid having to do that
manually. I already tried a macro, but it seems as if macros don't work
across multiple files. I don't need to copy all of the information over, but
rather information in specific cells. The information is in different
worksheets in the files. Does anyone know of anything I could do to make this
easier?

Automatically compiling many workbooks into one
 

Try this:
http://www.rondebruin.nl/copy3.htm

Or maybe this:
http://www.rondebruin.nl/fso.htm

You can find all of Ron de Bruin's tips he
http://www.rondebruin.nl/tips.htm

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Jor" wrote:

I'm needing to copy a bunch of information from a bunch of different excel
files into one massive workbook. I'm hoping to avoid having to do that
manually. I already tried a macro, but it seems as if macros don't work
across multiple files. I don't need to copy all of the information over, but
rather information in specific cells. The information is in different
worksheets in the files. Does anyone know of anything I could do to make this
easier?