Refreshing Excel Workbook with UIPath

[Rashmi (Rashmi Pareek)]

You can go through This thread :

Can we perform Refresh operation on excel file?

I have done this by running Excel macro from uipath. In Excel you can record / create vba code easily. Hope it helps

if you know macro above link can help you.

and

Automate excel data refresh

The “Main” is the name of the Sub or Function from the .vb file. In my example, I put there RefreshAll, because that’s how I called my Sub: [image] As to the file name, it should be a full one, including the extension. Also, make sure that you are only running this 1-line script from above. Your previous script is literally first getting the list of files, then opening each one and then doing the RefreshAll part. This is now all done in UiPath, so you only need to execute the RefreshAll part. …