Thanks everyone for your help. I do now have a script that works
greatly. It is also quite quick, even with 100 excel files open.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!