i am facing one issue in macro while running, it is generating dat file to text file.
for some of the files it is genertaing but for some of them it not working, it says macro is not enabled or trusted, but i have done all the required setting in macro enabled excel.
First check in options is macro disabled from Advance options by Admin. If you are doing through own system then just check macro which you created, what options you keep for trigger.
I recommend go with invoke macro from UiPath activities.
If you still not able to resolve, kindly share macro file. I will see if I can help you on this.