I don’t have much time for this today, but you are smart, you’ll figure it out. Here’s the deal:
Follow this instruction to set up a personal workbook and import or code your macro as needed:
In Studio, pick the Excel Application Scope, then add Execute Macro activity within. Edit MacroName like this: "'C:\Users\"+ Environment.UserName.ToLower +"\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB'!" + MacroNameVariable
Second option is to use macro enabled Excel files like this: How to use execute Macro - #10 by aksh1yadav
Invoke VBA code should be straightforward and there are plenty of examples in this forum and elsewhere online.
Good luck!