Hi please *help me* with the problem.

I have a around 300 workbooks each workbook contains employee
information. The workbooks are named as the employee code, starting
from 10512(e.g. 10512.xls, 10513.xls etc). I want to copy information
from various cells (ranges like first_name, second_name, etc) from each
workbook into one master sheet (master.xls) and I want to do it without
opening each sheet. Before copying I also want to concatenate some of
the information.

Can someone please tell me how to write a code for doing this and save
a ton of my time in the process?

Thanks.
:)


--
no27fiorano
------------------------------------------------------------------------
no27fiorano's Profile: http://www.excelforum.com/member.php...o&userid=17433
View this thread: http://www.excelforum.com/showthread...hreadid=378485