Skip to main content
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?

  • April 28, 2022
  • 1 reply
  • 107 views

Forum|alt.badge.img+3
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

Ashwin A.K
Forum|alt.badge.img+10
  • Navigator | Tier 3
  • April 29, 2022

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