Automatically compiling many workbooks into one

[Jor]

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?

 

[ryguy7272]

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 here:
http://www.rondebruin.nl/tips.htm

HTH,
Ryan---