472,973 Members | 2,230 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

home > topics > visual basic 4 / 5 / 6 > questions > error while generating excel report for 2nd time

Join Bytes to post your question to a community of 472,973 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 1774
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
Generating a report
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...
ASP / Active Server Pages
0
Excel Report in VB.NET
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...
.NET Framework
0
prob forms authentication while generating excel report
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...
ASP.NET
2
excel report generation
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...
C# / C Sharp
2
A4 format Excel report -- Java
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.
Java
5
Excel Report using ASP.NET
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...
ASP.NET
6
Saving images in Excel report
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...
PHP
1
Get a excel report with two tabs or excel worksheets
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...
ASP / Active Server Pages
2
How to embed image while genrating excel report in php?
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...
PHP
0
React to native button blinking effect
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
Software Development
2
isladogs
Access Europe meeting on Wed 4 Oct - The future of Access
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
Microsoft Access / VBA
0
How to find best mobile app development company in usa
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
Mobile Development
2
Energy Model code modification to account for year dependent interest rate
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
Python
4
NeoPa
Send Current Object to PDF
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
Microsoft Access / VBA
3
NeoPa
VBA Class Basics
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
Microsoft Access / VBA
0
isladogs
Access Europe Meeting - Wed 1 Nov - Using SQL Server skills to extend Access
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
Microsoft Access / VBA
0
isladogs
Access Europe Meeting - Wed 6 Dec - Streamline Your Import/Export Spec Workflow with VBA Classes
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
Microsoft Access / VBA
4
Take a Database to the Next Level
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...
Microsoft Access / VBA

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.

BYTES.COM © 2023
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!