https://community.hpe.com/t5/backoffice-products/vb-automation-error/m-p/3462409#M2435 I have an Excel based application having macros written in VB. It was working fine but now when I start my application it gives the following error.<BR /><BR />Compile error: Automation error<BR /><BR />Please let me know what is the problem. Thu, 13 Jan 2005 07:07:50 GMT Seetha Lakshmi 2005-01-13T07:07:50Z https://community.hpe.com/t5/backoffice-products/vb-automation-error/m-p/3462409#M2435 I have an Excel based application having macros written in VB. It was working fine but now when I start my application it gives the following error.<BR /><BR />Compile error: Automation error<BR /><BR />Please let me know what is the problem. Thu, 13 Jan 2005 07:07:50 GMT https://community.hpe.com/t5/backoffice-products/vb-automation-error/m-p/3462409#M2435 Seetha Lakshmi 2005-01-13T07:07:50Z https://community.hpe.com/t5/backoffice-products/vb-automation-error/m-p/3462410#M2436 If it just started this month there may be a bug in the code that handles the transistion from 12 to 1.<BR /><BR />Have you installed any upgrades?<BR /><BR />Could you have a macro virus?<BR /><BR />If you want to post the program as an attachment or send it to me directly (rkinner AT att DOT net) I'll be glad to look at it.<BR /><BR />Ron Thu, 13 Jan 2005 09:21:01 GMT https://community.hpe.com/t5/backoffice-products/vb-automation-error/m-p/3462410#M2436 Ron Kinner 2005-01-13T09:21:01Z