I have developed a report which retrieves the data from SAP and downloads to an Excel sheet on the local machine. But, the requirement from the client is... the client doesn't want to execute the report from SAP. There is a VB based EXCEL sheet on the local machine. In that, I have a PUSH BUTTON with name 'Get data from SAP'. So, When the user clicks the button in the excel sheet, it should execute the report in SAP and download the data into the same Excel worksheet.
Is it possible to execute an SAP report from the Excel sheet..?
If YES, what are the pre-requisites required and how can it be done.
If there is any useful information, please share. If someone help me in this regard with your valuable inputs that would be greatful.
Thanks in advance.