Hi
I need to save data as xlsx file downloaded from SAP. The SAP window has an excel button that shows an excel preview mode with multiple sheets and can be saved as it shows. I want to save it from that preview window because I can save it with the sheets.
The problem is I cannot use Excel VBO because the excel preview is embedded in SAP application, so it does not recognize as Excel file. Also, when I try to spy the embedded excel window, the application modeller does not recognize the window as well.
If I can use Save as action in Excel VBO, it will be easier and the best.
Is there any better ideas handling excel file interacting with SAP?
I need to save data as xlsx file downloaded from SAP. The SAP window has an excel button that shows an excel preview mode with multiple sheets and can be saved as it shows. I want to save it from that preview window because I can save it with the sheets.
The problem is I cannot use Excel VBO because the excel preview is embedded in SAP application, so it does not recognize as Excel file. Also, when I try to spy the embedded excel window, the application modeller does not recognize the window as well.
If I can use Save as action in Excel VBO, it will be easier and the best.
Is there any better ideas handling excel file interacting with SAP?