Loop through workbooks in a folder and return the value of cell M43
 

Greetings,

I apologize if this has been discussed before, but my search came up empty.

I need to write some code that will loop through all the workbooks in a
certain folder and retreive the value of cell M43 from each of those
workbooks.

Any help would be greatly appreciated. Thank you,

Loop through workbooks in a folder and return the value of cell M43
 

Hi RockNRoll

Try the example on my Tips page
http://www.rondebruin.nl/tips.htm


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"RockNRoll" wrote in message ...
Greetings,

I apologize if this has been discussed before, but my search came up empty.

I need to write some code that will loop through all the workbooks in a
certain folder and retreive the value of cell M43 from each of those
workbooks.

Any help would be greatly appreciated. Thank you,