Combine excel files into one sheet.
I need to write a macro to open all the excel files named as MyFile_200704_*
and insert into a new file Sheet1. How can I do this?
hi Jim
See this page for a example
http://www.rondebruin.nl/copy3.htm

Signature
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
> Combine excel files into one sheet.
> I need to write a macro to open all the excel files named as MyFile_200704_*
> and insert into a new file Sheet1. How can I do this?