That’s best practice, though. The only time you should use macros is when you can’t accomplish the task with UiPath activities. Macros, as you’re seeing, are unreliable and complicated - and will be difficult for others to interpret, support, and modify in the future.
Anyway, if you run the macro directly from Excel does it work?