473,327 Members | 2,081 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

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 1788
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

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

Similar topics

0
by: alexz | last post by:
Generating a report Alexander | Posted 11:05am 31. March 2004 Server Time | 3 Tables 1) Titles - The course titles 2) Courses - The schedules Courses 3) Students - Coueses a Student is...
0
by: krallabandi | last post by:
Hi, I am trying to generate Excel sheet using Provider=Microsoft.Jet.OLEDB.4.0; I am always getting the error while inserting data into any cell other than A. An unhandled exception of...
0
by: Raghavendra | last post by:
hi, we r using forms authetication. problem :- i am using the below code to generate excel report but since we r using forms authetication.. after generating excel report the browser directs...
2
by: kalaivanan | last post by:
Hi, dis is kalai and i am new to dis group. i am generating excel report in c# .net using microsoft excel 10.0 object library. the micrsoft office version which i am using is 2002. I can very...
2
by: devathi | last post by:
I have to display 16 columns in A4 size paper, am able to display arnd 4 columns in one paper. Suggest java program for generating A4 format excel report in which i can display any number of columns.
5
by: Rajesh | last post by:
Hi, Please help me to do an EXCEL report generation using ASP.NET. I am building an website. This should work in all machine. I need do load the data from SQL tables to excel sheet and user can...
6
by: Eddie | last post by:
Hi all, I am displaying a number of reports, and giving the users an option to display them on the web or download them to Excel. If they want the Excel file, I just use the PHP header command...
1
by: rinkkunitr | last post by:
i have one asp page from where i am calling a xml page.from this xml page i m calling two asp pages to get an excel with two different worksheets. The variable containing a string, having some values...
2
by: rupalee | last post by:
how to embed image while generating excel report in php? $excel=new ExcelWriter("report_'$date'.xls"); if($excel==false) echo $excel->error; // this will create heading of...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.