Executing OLE / Excel macro 4.7
Hi,
I have an ABAP that opens excel, downloads data and then should run a macro. The whole process works fine in 3.1 but not in 4.7.
In 4.7, all seems successfull until the following command:
CALL METHOD OF EXCEL 'Run' EXPORTING #1 = 'ProcessData'.
Does anyone know of a problem in 4.7? I don't think the issue is excel as the whole process works fine on the same client in 3.1 but not in 4.7. The sy-subrc code is 2 after this call.
TIA
I've resolved this problem myself. If anyone has a similiar problem, it appears that it was caused by a number of FREE OBJECT calls. One of them was:
FREE OBJECT RANGE.
Once I commented that one out, the macro ran fine.
could u send me the source code to my id vamsi_5@hotmail.com