I have some macro functions in an excel file. I need to call the functions often in my project. So every time i need to call a function, i have to use an excel application scope to open the macro file and then inside it use ‘execute macro’ activity. This will open and close the macro excel every time when i need to call a function.
Is there a better approach?
Can I run the macro code from somewhere else without opening the macro excel?