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?

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---

--
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?
>
>