Excel Error after automation

Alex · 1999-12-03

Hello,

I have following problem, i use the code below:

CREATE(xlApp); xlBook := xlApp.Workbooks.Add(-4167); xlsheet := xlApp.ActiveSheet; xlsheet.Name := 'Projekt Statistik'; ....... ...... .... xlApp.Visible := TRUE CLEAR(xlApp);

And if all datas are exportes to excel i get an Dr. Watson ( Error) afer i close Excel (manuelly) !

Anyone knows whats work, maybe i must unlink the session ?!

Luc_VanDyck · 1999-12-05

I use the following code with no problems:

<PRE>

//xlApp Automation 'Microsoft Excel 8.0 Object Library'.Application
//xlBook Automation 'Microsoft Excel 8.0 Object Library'.Workbook
//xlSheet Automation 'Microsoft Excel 8.0 Object Library'.Worksheet

CLEAR(xlApp);
CLEAR(xlBook);
CLEAR(xlSheet);
CREATE(xlApp);
xlBook := xlApp.Workbooks.Add;
xlSheet := xlBook.Sheets().Add;
xlSheet.Name('Projekt Statistik');
xlSheet.Range('A1').Value := 'This is cell A1';
xlApp.Visible(TRUE);
CLEAR(xlApp);
CLEAR(xlBook);
CLEAR(xlSheet);
</PRE>

Alex · 1999-12-06

Thanks, but i have the same Problem.
If i don't save the Excel sheet i get an Program
crash :-(

P.S.: But thanks anyway ...

Jem_Ahmet · 2000-01-05

I had the same xl problem (XL 8.0): ERROR when I close XL before closing the report.
I was using only CLEAR(xlAPP), but when code as Luc:
CLEAR(xlAPP)
CLEAR(xlBook)
CLEAR(xlSheet)
everything is OK,
10x Luc <img border="0" title="" alt="" src="images/smiles/icon_smile.gif" />

Luc_VanDyck · 2000-01-05

Just remember where you saw the answer ;-)

Alex · 2000-01-06

Thanks i works, if i use the CLEAR Funktion
befor and after the Code !!!

Thanks Alex

Excel Error after automation

Comments

Categories