after opening an excel doc with actve X, crashes when calling excel again 
Author Message
 after opening an excel doc with actve X, crashes when calling excel again

i created an application that allows the user to read in an excel
spreadsheet, chop it up, then stuff it into a database. it also can generate
2 reports as excel spreadsheets . when i run the reports alone it works fine
but when i chop up the spreadsheet it tnds to{*filter*}up excel. it does not
cause any faults but it does cause excel to open like this: all you see is
the frame of excel you don't see the  contents of the doument, in fact you
see right through the window to the background.
in the spreadsheet chop i use all active X calls to open the document in the
background, read it then close the document..
for the reports i create the documents by writing the file with "write to
speadsheet file" then opening the doc within excel.

any ideas?



Tue, 12 Oct 2004 08:44:34 GMT  
 after opening an excel doc with actve X, crashes when calling excel again
Shawn,

My only idea is to make sure that all ActiveX references are closed to
Excel (every ActiveX wire should end in a Automation Close function).
Other than that, it may be an issue with the ActiveX object for Excel.
Contacting Microsoft may be a possibility.

Randy Hoskin
Applications Engineer
National Instruments
http://www.ni.com/ask



Tue, 12 Oct 2004 23:09:45 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. convert txt excel file without open the excel application

2. Calling DVF dll from Excel: Excel macro problem?

3. my application crashes when i call Excel

4. Excel macro causes a crash when called from Labview

5. realbasic to excel/realbasic vers excel

6. how to create an excel workbook using the excel toolkit

7. Excel toolkit --excel save.vi is broken arrow

8. Using Win32OLE with Excel leaves Excel process hanging

9. Looking for Excel API library (XLCALL.LIB) for Excel 7

10. Need Excel & Explorer OCX / Automation Doc Referance

11. Excel OLE again

12. open existing instance of Excel , getObject

 

 
Powered by phpBB® Forum Software