I am experimenting with Sub Example2(), my worksheets both in the source and
destination have names. Where in the code do I specify these names? I need
to pick information from various cells.

Ron de Bruin wrote:
Yes change the folder name and range and try it

Thanks Ron,
I am not an expert but let me study your suggestions and I will let you know
[quoted text clipped - 12 lines]
label in each file) into one Excel file , each source file info going to one
row in the destination file.

--
I travel 3rd Class because there is no 4th Class- Gandhi.

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200604/1