Step:
1.Open the xls Excel, refer to attachment
2.press F12(or Fn+F12), then pop up save as window
3.Select CSV(Comma delimited), fill in csv file name
4.Click “Save” button
test.xls (24 KB)
Step:
1.Open the xls Excel, refer to attachment
2.press F12(or Fn+F12), then pop up save as window
3.Select CSV(Comma delimited), fill in csv file name
4.Click “Save” button
test.xls (24 KB)
HI @Lori
Correct me if iam wrong this popup is not appearing all the times when you save them?
Regards
Gokul
Hi!
In which step you were stuck ?
try this:
1.Excel Application scope
2.Read Range to read the entire sheet
3.Send HotKey to send the F12
4.Select item to select the csv format
5.Type into to type the data
Regards,
NaNi
If yes ,
You can try like this
Regards
Gokul
Okay So Can you elaborate on your task bit mor?
I description my step in body, my issue is when manual per my steps, that window pop up, when robot, that window disappear. I need this window and click Yes, it can keep some special characters format。
Hi!
use delay activity!
Regards,
NaNi
I need this window and click Yes, it can keep some special characters format. however, when robot click save button, this window cannot pop up.
Have you enabled the Visible property in Excel Application Scope if you use that ?
Regards
Gokul
testExcel.xaml (24.2 KB)
Just give it a try with excel modern Activities by enabling show excel alerts in project settings
Regards
Gokul
I had add the process, Please help to check, thanks.
Means that it is not appearing in the foreground for clicking right?
I will test next week and reply, thanks.
If this is your cause you can try with Activate Window Activity
Okay Great let us know if it resolved? Happy Weekend!!!
Regards
Gokul
@Gokul001
Hi, I test per your method, the element exist output is false, can not get that window and click “Yes” button.
Hi!
could you please re-indicate the Element Exists activity on Button instead of text?
Regards,
NaNi