How to run a macro in a new file each time

I am converting a xlsx file that I get from a folder to a xlsm. I am then trying to exeute a marco on the xlsm file. However, the macro does not run properly. When I put in a short key in the job it brings up an empty list of marcos even though the marco is saved to my personal workbook. Is there a way to pull the macro from a folder to run on the new file, or do you have any suggestions on what would fix my current issue?

not sure if this is what you want. but i hope it helps.

1 Like

macroFolder is where your macroexcelsheet is.

ECOD Format Data is your macro excelsheet name.

formatData is the method you are calling.