View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
igorek igorek is offline
external usenet poster
 
Posts: 38
Default retrieve cell value from the cosed file

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