Posts

Showing posts with the label word-vba

Calling a macro (in Word document) from Excel macro using document name a runtime

Calling a macro (in Word document) from Excel macro using document name a runtime I need help in triggering a sub in a word document from Excel VBA. I want to use the Word document name at run time while calling the macro from Word document. I have done similar thing for PowerPoint and I want to replicate the same for word. Code snippet used for PPT: objPPT.Run "'" & StrPPTName & "'!ModuleName.Sub-Name", arg1, arg2 I am not able to do the same for Word, please suggest. "I am not able to do the same for Word" why not? What did you try for Word and why didn't it work? What errors did you get? – Pᴇʜ Jun 29 at 6:46 In addition to what @Peh says: Is this MAC or WinWord and which version of Office? Use the edit link below the question to add information or make any cha...