Linked Code To Button Workbook.A: Sub Open_External_Workbook() I have have dabbled in VBA for a while and usually find a solution, but this one I have had for the first time ask for help.
I have a Macro.A that applies formatting and I want to be able to apply this formatting to a predefined workbook that contains no macros so I need to execute Macro.A in Workbook.A on Workbook.BĪn help is greatful. The Second file is the file to formal as stated in the first paragraph. is=t doesn't have the macro, but I need to excute the macro from ConvertToMacroEnabledWorkbook.xlsm onto DailyReport_Canada.xlsm. This file also contains the Macro to format the second file DailyReport_Canada.xlsm.
xls and not macro enabled so I found a script that converts them to xlsm files. The First File ConvertToMacroEnabledWorkbook.xlsm because initially I though is was because the file originally come as.
0 kommentar(er)
