Hi Igorek,

See Ron De Bruin's 'Copy cells or sheet from all or some workbooks in a
folder' page at:

http://www.rondebruin.nl/copy3.htm


---
Regards,
Norman



"igorek" wrote in message
...
Hello,

I have 400 files in the direcrory of the identical format. in order to
create a proper check tool i need my code to go into every single file
pick
up values in cells A1 and B1 and populate these values in the
ActiveWorkbook
in the following manner
A1 B1
File 1 x y
File 2 y z
File 3 w m

Thank you
Igor