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?
macroFolder is where your macroexcelsheet is.
ECOD Format Data is your macro excelsheet name.
formatData is the method you are calling.