Hi Wouter,

I checked and indeed these four are enabled/checked. I am using Excel 2003
SP3 Professional edition. I haven't had a chance to get back to this until
today. Was hoping to get your insight on they syntax error. I am a newbie
with this stuff and don't know what might be causing this. I copied your
post and get the error.

Thanks for your help,

"Wouter HM" wrote:

Hi C,

Please check in your VBE Tools -- References.
On top of the list thses four should be checked:

- Visual Basic for Applications
- Microsoft Excel n Object Library
- OLE Automation
- Microsoft Office n Object Library

Which version of Excel ar u using?


Wouter
.