468,457 Members | 1,771 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,457 developers. It's quick & easy.

Error while generating excel report for 2nd time

Hi.,
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 1551
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.

-Stewart
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
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.