How to run a macro in a new file each time

excel
activities
macro

#1

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?


#2

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


#3

macroFolder is where your macroexcelsheet is.

ECOD Format Data is your macro excelsheet name.

formatData is the method you are calling.