473,587 Members | 2,580 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 1802
Stewart Ross
2,545 Recognized Expert Moderator Specialist
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
1226
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 taking and the student attendance Relationships are Titles.ID on Courses.TitleID
0
1180
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 type 'System.Data.OleDb.OleDbException' occurred in system.data.dll
0
1432
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 to login.apsx which is specified in web.config file. this code is in one file.aspx
2
2711
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 well generate the excel report. I have implemented the same application in a system with office 2000. I am not able to generate the report. The error...
2
2783
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
2297
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 modify the data in the excel sheet. Then i need to get the data from modified excel sheet and generate the graphical Chart. But the machine need...
6
8059
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 to change the Content- Type and Content-Disposition headers, and essentially print the same report, and it's done. That works fine. But in some...
1
6665
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 like 32,45,57.. My problem is for long string ,(more than 150 characters) it shows error...problem in loading...Please told how to overcome this.......
2
2415
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 each column in excel file //$myArr=array("Enquiry ID.","Enquiry Title","Enquiry History","Enquiry Keywords","Enquiry Start Date //","Enquiry End...
0
7918
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7843
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
1
7967
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8220
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5713
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3840
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3875
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2353
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1452
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.