Using FM: ALSM_EXCEL_TO_INTERNAL_TABLE

[Former Member]

Howdy,

Im using the FM: ALSM_EXCEL_TO_INTERNAL_TABLE to upload an MS Excel file to an internal table which works fine. The problem is that the MS Excel process (via Windows Task Manager) is not getting terminated. This results to to many instance when running a the same function module several times. I looked at the source code and line #102 clearly states the said problem.

Any solution to kill/terminate the EXCEL process?

Im using SAP 4.6C. Thanks.

Cheers,

Kelvin Dela Rosa

[matthias_fiebig · Accepted solution]

Hello,

it seems to be a fix at 4.7 enterprice

• >>>>> Begin of change note 575877

• to kill the Excel process it's necessary to free all used objects

FREE OBJECT h_cell. m_message.

FREE OBJECT h_cell1. m_message.

FREE OBJECT range. m_message.

FREE OBJECT worksheet. m_message.

FREE OBJECT workbook. m_message.

FREE OBJECT application. m_message.

• <<<<< End of change note 575877

I hope this helps you.

Matthias

[Former Member · Accepted solution]

Hi Matthias,

Yes, this is the answer. Since we are still on 4.6C we need to apply SAP Note 575877.

Thanks. I gave you 10 points for giving the solution.

Cheers,

Kelvin Dela Rosa