Quote Originally Posted by June7 View Post
Oops, copy/paste error on my part - I copy/pasted OPs code for macro name part to replace my macro name. My corrected code without extra apostrophe:

Application.Run "'" & Application.GetOpenFilename & "'!MakeFinalVendors"
Apostrophes around macro name are not required but will work.
Ahh, yes, I had not noticed that you also had that error.
I learnt something as well. I never noticed that one could do away with the Apostrophes around the macro name.
(Access to the forum seems better for me today)