Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from horacio zapettini on Mar 27 at 11:24 AM Pratibha,
You may want to google "abap excel ole2_object macros"
We've used a solution based on Ole2 for a long time (since 2000) and it works fine.
Of course it's an old fashioned solution? but, IMO, something is better than nothing?. Isn't it?
(BTW, check the groups posts. I think this question has been solved many times in the past in SAP-DEV and SAP-ABAP)
horacio
De: Community_Member [mailto:email@removed]
Enviado el: lunes, 27 de marzo de 2017 06:35 a.m.
Para: Horacio Zapettini
Asunto: [sap-dev] How to Download Data from SAP Into Excel With Macro for Conditional Formatting
Question from Pratibha on Mar 27 at 5:36 AM
Hello Experts,
I need to download data from SAP to Excel. First column of the Excel is blank. We need the moment user enters any value, the colour of the cell should change.
This can be done via Macros. But how to write macro in excel from SAP?
Please help.
Thanks in advance.
Praibha
Reply to this email to post your response.
| | | ---------------Original Message---------------
From: Pratibha
Sent: Monday, March 27, 2017 5:38 AM
Subject: How to Download Data from SAP Into Excel With Macro for Conditional Formatting
Hello Experts,
I need to download data from SAP to Excel. First column of the Excel is blank. We need the moment user enters any value, the colour of the cell should change.
This can be done via Macros. But how to write macro in excel from SAP?
Please help.
Thanks in advance.
Praibha |
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
