Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

excel sheet download

Former Member

‎04-02-2009 11:08 AM

0 Kudos

Hi Experts,

I have a query regarding excel sheet download, i have a excel sheet with all macros validations done as a seperate file. now i want to provide this excel sheet to the user once he clicks on download excel sheet on his report selection screen. is it possible to provide a excel sheet along with macro validations done in it.

2 REPLIES 2

Former Member

‎04-02-2009 11:54 AM

0 Kudos

Hi,

We can achive this using OLE (object linking and embedding) to download into excel sheet.

Regards,

Nitin.

Former Member

‎04-02-2009 11:56 AM

0 Kudos

Hello Asif,

The standard SAP report "download to excel functionality" does not have provision for pre defined excel sheet download.

In case you want to have a excel sheet with pre defined macros , you will have to interface your excel with SAP logon and then pull data from the report to the sheet with macros . OLE DB connector is used for this purpose and VB coding will also be required in this case.

Regards