Open specific Excel file

Help Studio
, ,
1

Hello ,

I am facing one issue while developing a project. In this I have to open a specific excel file and perform some activities in it like opening another excel file using UI ( File ->open-> choose Macro ->run macro etc.)

How can I do this in UiPath ? Opening an excel

Your response will be highly appreciated as This one is urgent

2

@wooowwooty
Welcome to Uipath Community

First of all save the macro code in a .txt file manually
then
Use open excel application scope and give the specific filepath
then use invoke VBA activity inside it
Provide the .txt script file path
run the macro

Attached SC for your reference

image
image812×482 14.9 KB

3

HI @wooowwooty

Welcome to Community!

Checkout this activity(Execute macro) it will execute your macro of that specific excel

Regards
Sudharsan

4

Also please make sure the macro is enabled in the excel

To enable macro go to any excelfile then go to file>Options>Trust Center>Trust Center settings> Macro setting> enable all macro

image
image1362×900 52.9 KB