I have been tinkering with this excel for several days, and find no solution. Have also implemented several solutions from the forums but I still cannot solve mine. Its actually a simple flow of running an excel which contains a macro that if I run that macro it will change the formatting of another workbook.
the problem is, I got the message “Execute Macro: Cannot run the macro ‘RunMacroInOtherWB’. The macro may not be available in this workbook or all macros may be disabled” when executing the macro. I have tried another by separating the excel and vbs, but got “HRESULT: 0x800A03EC” instead, i have put kill process but not solving either.
so what is the best approach for this, and how do i fix this? appreciate any answers
TrialRunMacroAnotherWB.zip (44.8 KB)