Save as

[Bluemoon]

How do you set Automation Anywhere to save an excel using the save as comand

[forumstaff]

Hello Bluemoon,

You will have to follow "Insert Keystroke" command with proper keystroke sequences for saving the spreadsheet with "save as" option.

Ideally, you can open spreadsheet using excel command, make the changes you want on it and then use "Insert Keystroke" command for saving the spreadsheet with "save as" option. You can follow the keystroke sequence of:
1) Alt+f
2) a

Let us know if you have any doubts.

Thanks & Regards.

[trentonponder]

Another option that may be better for some that does not involve opening dialogue boxes on the screen.

You can save the file as you normally would, then use AA to copy and rename the file. If you want you can then delete the original file.

As a general rule, I always avoid having AA open any windows if there is a workaround. I`ve found opening and closing windows to be the single biggest cause of task crashes.