All I want to do is save the newly created workbook but I get the error "cant find open session" without opening an already existing workbook. If I do that, then AA wants to save that workbook instead of the exported one when I put in the save workbook action. What am I doing wrong?
Hi Dean,
When ever you export any report from SAP to excel, the file will be opened immediately once after it downloaded to our local system.
Please try to use "close window action" with title as your downloaded sheet name, it will close the excel application.
Now you can use open the downloaded excel with session name and you can proceed with your excel operations with the session name.
Hope it helps you.
Happy Automation😊
Sai Krishna.
Hi Dean,
When ever you export any report from SAP to excel, the file will be opened immediately once after it downloaded to our local system.
Please try to use "close window action" with title as your downloaded sheet name, it will close the excel application.
Now you can use open the downloaded excel with session name and you can proceed with your excel operations with the session name.
Hope it helps you.
Happy Automation
Sai Krishna.
Except that the downloaded file is NOT an Excel file, it’s a .sapaox SAP Analysis type file that cannot be opened with the Excel open action. So how do you assign an Excel session to this type of SAP file in the local directory?
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.