Martin,

What I have done before is to use a workbook as a program that open
each workbook (once at a time), perform the scan, do the actions, and
close the workbook before moving to the next one. It runs fast. I am
not sure you can do it with the workbooks closed, however I will double
check and will get back to you by tomorrow. Let me now if you need the
program that perform the scanning.

Regards
Juan Carlos


--
cscorp
------------------------------------------------------------------------
cscorp's Profile: http://www.excelforum.com/member.php...o&userid=24015
View this thread: http://www.excelforum.com/showthread...hreadid=376983