Execute Macro From Another Workbook NOT resolved

[Spajeoly]

So, in dealing with custom menu I see that you can assign a macro to a menu item like so 'C:\Book1.xls'!MacroName

So how do we do this same action in VBA?

I am going to start playing with it (Haven't even tried it yet), but I like to put these questions out there.

[Spajeoly]

Ah Ha! Got it...

 Run "C:\Book1.xls'!MacroName"

[Spajeoly]

Ok, in 2007 it does not work the same. All that code will do so far is open up the work book but not execute the freakin' Macro.

Anyone with 2007 and experience working with this?

Update

It would work, but what I am doing is assigning it to a hotkey in the Personal Macro Workbook. If you Alt F8 and run it from the macro list it works fine.

Weirdest thing, it doesn't run the macro when the hotkey is pressed.

Eh?