possible to loop through folder to extract to cell values?

[jinx_uk_98]

Hi Guys,

Back again looking for somemore expert guidance.

Is it at all possible in VBA to loop through a folder (and sub folders) and copy 2 cell values (sheet name 'may' cell d1 and d2) for example

Then paste this into another workbook along with the workbook name from which it was copied? in some cases there will be null in d1 and d2.

Cheers as always
Kevin

 

[Weaver]

Yes, this is very possible, and has been covered many times on this board.

A quick search uncovered this, which ought to get you started.

http://www.mrexcel.com/forum/showthread.php?t=547274