Hi, I have a macro in Excel that inserts a new sheet based on the excisting sheet but when I run it from Studio using Execute Macro activity I get a blank sheet. It is the first part of the code that goes wrong - the copy is not excuted properly. The VBA code is: [NewYearSheet]

Found the error! Before calling the macro from UiPath I was using an Excel activity FindFirstLastRow in UiPath. This activity creates an empty sheet and throws an error if the sheet does not excist in Excel. So because an empty sheet was created my Excel macro could not run properly and the result …

Execute macro does not run as expected

Help Activities

postwick (Paul Ostwick) November 3, 2022, 11:40am 8

Why would your macro be called from within Excel? Aren’t you building an automation? What is your goal here?

Topic		Replies	Views
Execute macro - Macro doesn't work the same as executed manually Help	15	5557	December 15, 2022
UiPath Macro Update in Excel Activities excel , uiautomation , activities , studio , question	9	411	October 26, 2023
Running macros from UiPath (macro code written in uiPath) Help excel , studio	6	6522	October 20, 2019
Execute Excel Macro within specific sheet of workbook Activities excel , uiautomation , macro	7	1894	August 13, 2023
How To Run Macro On Uipath please help Studio	2	718	November 8, 2021

Execute macro does not run as expected

Related topics