Open excell file on share an run macro with parameter

[dhorions]

I don't know much about excel and I have to write an abap program that opens an excel file on a network share and jumps to a row specified by a parameter passed from sap.

Can anyone point me in the right direction? I did some web searches, but don't even know what search term are likely to give results.

I did succeed in making a macro that jumps to a row containing the value, I just don't know how I make the macro pick up the value from the abap call. I open the file with cl_gui_frontend_services=>execute.

Thanks in advance,

Dries

[gregorw · Accepted solution]

Hi Dries,

I'm not a Office programmer. I've done creation and reading of Excel Tables via a Web Service which I've implemented as described in my Blog <a href="/people/gregor.wolf3/blog/2006/09/01/excel-to-csv-conversion-with-a-php-web-service to CSV conversion with a PHP Web Service</a>. To write a Excel File you can use <a href="http://pear.php.net/package/Spreadsheet_Excel_Writer">Spreadsheet_Excel_Writer</a>.

Regards

Gregor