Excel save as issue!

Help
1

Hello Community, Please check my codeUisend.xaml (16.7 KB) and fix the issue.
image
Bot stop after this activity. And here is need to add file name + today’s date + specific location.
Note: Manually it works. Bot can’t perform after this activity(Type into Edit)

1 Like
2

Hi @Jesmine

Try to put all the activities inside excel application scope and check it once

Thanks
AshwinS

3

Hi @Jesmine Try putting everything in Excel application scope and run it again.

Thanks,
Adit

4

hello @Jesmine

i did some modification to your workflow have a look Uisend.xaml (25.4 KB)

by the way i commented select item activity , it will not work if you use select item, it will save the file like filename.prn.xlsx so i have used some work around.

regards
Ajay

5

Hi @Jesmine

Make sure also that if you use TypeInto Activity the application is on the foreground.

I debug your xaml and here is the result.

image
image700×521 14.2 KB

cheers :smiley:

Happy learning :smiley:

1 Like
6

Hello @AshwinS2,Afterthat image
This window is not appear.
I need to appear this window.

7

Hello @Ajju ,Afterthat image
This window is not appear.
I need to appear this window.

8

Hello @Adit2917 ,Afterthat image
This window is not appear.
I need to appear this window.

9

Hi @Jesmine

Is it mandatory?

I guess it is just a warning to user.

Check the results if results ok then you can avoid that window.

Ajay

10

Hi @Jesmine
Use Element exists

then click No

Thanks
Ashwin S

11

Hello @Ajju,
This window will appear when I will work manually the same process. In cause of it’s mandatory.

12

@Jesmine

This kind of things happened to me as well but sometimes when i was trying manually some windows will not appear but when robot doing the same thing some kind of warning messages will appear.

It depend on your call

If you want to handle it use element exists
If element exists click yes otherwise click no

Regards
Ajay

13

Hello, Showing following errorimage

14

Hi @Jesmine

Your sending hot key called Alt+F4 to close the workbook but still there are some activities inside workbook…

Possible solution is to remove Alt+F4 or move the remaining activities out of excel

Ajay

15

Hi ,
you can use the Save as workbook activity form the below package.

Regards
Balamurugan.S