Question

I have created a bot to run a report in SAP and export it into excel. It runs great until I have to save the exported excel workbook. Do I use a SAP function or an Excel function to save the file?

  • 28 April 2022
  • 1 reply
  • 9 views

I have created a bot to run a report in SAP and export it into excel. It runs great until I have to save the exported excel workbook. Do I use a SAP function or an Excel function to save the file?

1 reply

Userlevel 3
Badge +7

Hi @dean mcghee​ ,

 

You have to first detect the Excel Window and then use Simulate Keystrokes F12 to invoke the Save As Window.

Then, you detect the Save As Window and pass in the Filepath.

 

Could you give that a try?

 

Kind Regards,

Ashwin A.K

Reply