>It does not matter, workbook_open or auto_open, for me they never fire in Automation. It would be useful to understand what is 'special' in your workbook. I would appreciate if you create a sample to reproduce the behaviour and send it to me.
>
>Anyway this may help you:
>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/modcore/html/deconWorkingWithDocumentsThatContainStartupCode.asp

You must have Excel 2002 which works properly. I have found that 2000/97 had a bug in automation :

XL2000: EnableEvents Property Does Not Work in Automation Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q211626

XL97: Controlling Events in an Automation Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q184000

The only workaround that Microsoft gives for it is to not use WorkBook_Open but to use Auto_Open. I'll check your link though.

Thanks,
Jamie