topic Re: inserting macro using OLE in excel in Application Development and Automation Discussions

inserting macro using OLE in excel

Former Member — Fri, 29 Mar 2013 12:25:47 GMT

Hi All,

I am downloading an excel through my abap program using GUI_DOWNLOAD.

My requirement is to open/read that excel and apply macro to it, so that it comes out formatted in the end.

Earlier, i used OLE methods to format the excel . But due to large amount of data, it takes lot of time to format every cell of the excel.

Can anyone please let me know how i can apply macros to my excel , using OLE or any other method.

i read somewhere that you need to insert the macro file using OLE into the excel spreadsheet first, but i m not sure how that needs to be applied.

I am really new to OLE methods.

Thanks in Advance

Bhavika

Re: inserting macro using OLE in excel

matt — Fri, 29 Mar 2013 13:32:42 GMT

If you only want to format the output of the spreadsheet, forget macros: use abap2xlsx http://scn.sap.com/community/abap/blog/2010/07/12/abap2xlsx--generate-your-professional-excel-spreadsheet-from-abap

This has the added advantage of working in background as well.

matt

Re: inserting macro using OLE in excel

Former Member — Mon, 01 Apr 2013 05:06:24 GMT

Hi Mathew, i will try the suggestion you have provided.

can others provide me any other alternate solution / or how to use macros in OLE.

Thanks

Bhavika

Re: inserting macro using OLE in excel

Former Member — Tue, 02 Apr 2013 05:17:07 GMT

Hi Mathew,

Can you provide me some sample code for formattig excel using abapxlsx.

Thanks in advance

Bhavika

Re: inserting macro using OLE in excel

matt — Tue, 02 Apr 2013 06:02:31 GMT

Google for it and you'll find plenty of examples.

Re: inserting macro using OLE in excel

sreehari_vpillai — Wed, 07 Aug 2013 14:32:12 GMT

Hi Bhavika,

Was it an April fool

We can use OLE only if the file that you are trying to acess is found at client machine. Through GUI download, first you have to make the physical file avaialble at a specific location. Then you can start the OLE functioning.