Application.Run "'Ceiling grid diagram.xlsm'!Mew"
I use that in one of my commandbutton codes at the end to fire a macro.

And yes. The macro is named Mew.
As most anything I come in contact with is also named.


Hope that helps, if not, lemme know and we'll get something figured out for ya!

mew!