Hi all my doubt is, I have a desktop application in that application I am clicking on Export to Excel tab, so the excel page is opening but not getting saved anywhere. Now I want to save that excel and move to a different folder. How can I save and move.
Note: the excel is just opening but not getting saved anywhere.
Thanks in advance
Try this way:
=> Click "Export to Excel"
Wait for Excel to Open
=> Send Hotkey "Ctrl + S" (Save)
=> Send Hotkey "Enter" (Confirm Save)
=> Type Into: Enter Destination Folder Path
=> Type Into: Enter File Name
=> Send Hotkey "Enter" (Confirm Save)
=>Send Hotkey "Alt + F4" (Close Excel)
=>Move File: Move Saved Excel File to Desired Folder
Hope it helps!!
If it’s opening in Excel it has to be saved somewhere. File/Info will tell you where.
Hey you can try putting the export to excel button - click activity in wait for download. So when the file opens, you will be able to get the file variable and using FullName (E.g:- File_Variable.FullName) will provide the full path of the file
If you are able to save the excel file by using the Keypad shortcut keys.
In Automation you can use the Keyboard shortcuts activity to give Ctrl+S which used to save the file after that we can give the name of the file and save by using Ui activities.
Hope it helps!!