topic Re: Problem with Excel OLE in Application Development and Automation Discussions

Problem with Excel OLE

Former Member — Mon, 25 Jul 2005 14:34:16 GMT

I'm creating an Excel worksheet with OLE and Excel Macros and the file is created without any problems. The only issue I have is that when you close Excel, the process in Windows keeps running (CtrlShiftEscape to view the process EXCEL.EXE). Is this a known issue with Office 2003 or a problem in SAP4.6C with the OLE2 connection not closing properly.

TIA

Re: Problem with Excel OLE

Former Member — Mon, 25 Jul 2005 14:36:57 GMT

first call quit application then free object

CALL METHOD OF gv_excel 'QUIT'.

FREE OBJECT gv_cell.

FREE OBJECT gv_excel.

FREE OBJECT gv_books.

FREE OBJECT gv_sheet.

take a look on FM ALSM_EXCEL_TO_INTERNAL_TABLE lines (112) just before the end of the function, to see how sap deal with this problem.

Re: Problem with Excel OLE

Former Member — Mon, 25 Jul 2005 15:54:46 GMT

Thanks for the fast reply Joseph, but unfortunetly, I don't want to close Excel automatically. The user must be able to visualize the file. I still tried the 'QUIT' method and the FREE OBJECT (which I already had) and it didn't work because the FREE OBJECT cell, workbook and range return errors. Any idea as to why they return errors (even if I QUIT excel).

Re: Problem with Excel OLE

Former Member — Mon, 25 Jul 2005 16:07:54 GMT

NM. I found the problem (I changed the code and was freeing objects that weren't used, so they weren't instanciated). Now it works fine. Thanks Joseph.

Re: Problem with Excel OLE

Former Member — Mon, 25 Jul 2005 16:17:51 GMT

I was about the response you to check your code

(Le plaisir etait pour moi)