Down load data to excel sheet

[Former Member]

Hi Experts,

I am downloading my report output to an excel sheet so that i can plot the graph from there.

Is there any way so that i can save the settings of the graph and when i download my report to the same file next time,,it plots the graph automatically or is there any macro from which i can draw my graph with the previous settings which i made when i downloaded for the first time.

Thanks.

[Former Member]

Hi,

you need to use Excel OLE functionality

I have collected a few links for you, enjoy:

reference for OLE automation:

<a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/wiki?path=/display/snippets/creating%2bexcel%2bwith%2bmore%2bthan%2bone%2bpage">https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/wiki?path=/display/snippets/creating%2bexcel%2bwith%2bmore%2bthan%2bone%2bpage</a>

OLE automation book

<a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/59/ae3cac488f11d189490000e829fbbd/frameset.htm">http://help.sap.com/saphelp_nw2004s/helpdata/en/59/ae3cac488f11d189490000e829fbbd/frameset.htm</a>

<a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/59/ae3d32488f11d189490000e829fbbd/frameset.htm">http://help.sap.com/saphelp_nw2004s/helpdata/en/59/ae3d32488f11d189490000e829fbbd/frameset.htm</a>

<a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/59/ae3c98488f11d189490000e829fbbd/frameset.htm">http://help.sap.com/saphelp_nw2004s/helpdata/en/59/ae3c98488f11d189490000e829fbbd/frameset.htm</a>

regards,

Joris Bots

Message was edited by:

Joris Bots