calling to xlam macro from macro inside xlsb
Hi all.
I just finished a macro that is located in my xlsb file- Macro1.
I now have need to call to a macro located in my xlam file (MacroB), from Macro1. I've set MacroB(Optional Control As IRibbonControl) so it can be accessed from other macros within my xlam file.
I've tried
call pathname\MyXlam.xlam!MacroB
application.run (pathname\MyXlam.xlam!MacroB)
" " "pathname\MyXlam.xlam!MacroB"
and none of these work.
Is there a way to call an xlam macro from an xlsb file?
Thank you.
|