I tried your VB script and works wonderfully except for one detail.

Every time I run the script, after it is done, it pops up a 'File
Available for Use' window telling me that my excel file is available for
editing giving me the option to open it as 'read/write' or 'cancel'.
It's doing this everytime. Is there a way to shut this off? Other than
this, I've run the script multiple times and works just fine.

-Sofia

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