It's been a long time, so, I'm probable wrong, but...

I believe that you will need to access the desired macro thru a sub in ThisWorkbook.

Dim X As new Excel blahblah
X.SubToRunDesiredMacro

X + Dot + Name of Macro in ThisWorkbook