Solved: Excel run a Word macro?

[Paul_Hossler]

I have an Excel WB create a Word document from a Word template with Word macros in it. (CreateObject, etc.)

What would be the Excel command to execute a macro in the Word document?

I can probably sort out the detals, but the cross-app control is where I'm stuck

Paul

PS - we're talking 2007/2010 versions

[Tinbendr]

Check out Application.Run in the help files.

Should be

appWord.Run module1.mymacro\

David

[Paul_Hossler]

Hi David

I've used .Run before, but never thought about using it between apps

Thanks

Paul