471,120 Members | 1,418 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,120 software developers and data experts.

Error while generating excel report for 2nd time

I have an ActiveX control which is been pin in the SolidWorks task pane. I am generating an excel and pdf report. The problem is i am able to generate excel report very fine in the first attempt, but when i try to generate again for the second time it s displaying error " Run- time error '440' Automation error" and another error "Run- time error '91' object variable or with block variable not set", if i reload the application twice it is possible to generate the report properly, and actually i will be closing the excel file after doing saveas, even then task manager consists of process EXCEL.exe.

Please do the needful.
Nov 17 '10 #1
1 1622
Stewart Ross
2,545 Expert Mod 2GB
You'll need to post the code concerned before we can help you. The most likely cause of the problem is that your Excel automation object is not being referred to explicitly by your automation code - but without the actual code used I can't tell.

Nov 17 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by alexz | last post: by
reply views Thread by krallabandi | last post: by
reply views Thread by Raghavendra | last post: by
2 posts views Thread by kalaivanan | last post: by
2 posts views Thread by devathi | last post: by
5 posts views Thread by Rajesh | last post: by
6 posts views Thread by Eddie | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.