UiPath Macro Help needed

[Palaniyappan (Palaniyappan P)]

@Ritaman_Baral

There is one more scenarion.
The macro A has a dynamic path .
The bot needs to edit the macro in the excel itself.
how to do that ?

Well u can use excel application scope and use execute macro within that
Have a view in this thread with similar scenario and git resolved

Hope this helps

Excel Macro Code issue

Hi, Did you tried like below. thanks. Sub Formatting(FilePath As String) With ActiveSheet.QueryTables.Add(Connection:=“TEXT;” + FilePath, Destination:=Range(“$A$1”)) [image] [image] [image]

Cheers @Ritaman_Baral