I have excel operation where i need to perform Refresh operation on it? Is it possible to perform Refresh using Ui-Path on excel or is there any workaround for this?
Regards,
Ahtesham
I have excel operation where i need to perform Refresh operation on it? Is it possible to perform Refresh using Ui-Path on excel or is there any workaround for this?
Regards,
Ahtesham
I have done this by running Excel macro from uipath. In Excel you can record / create vba code easily.
Hope it helps
Hi @md.ahtesham,
To refresh or recalculate in Excel (when using the F9 for The Financial Edge), you normally can use the following keys:
If you have any issues with the above option refreshing, please try:
CTRL+ALT+SHIFT+F9
as per the below article:
https://kb.blackbaud.co.uk/articles/Article/49534
Here is some link to a similar discussion, where VBA script was discussed:
And perhaps this will be of some use:
does this help?