Question Locked

How to run a macro in an embedded word document via Excel VBA

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have an Excel workbook with an embedded word document. Is there a way to run a macro that is part of the word document via Excel VBA?

3 replies

by triathlete1981

Really depends. 2003 version? Excel doesn't open the same way Word does, so if you're using a VB script everytime you open Word, such as an auto save script, than applying it to the normal.dot will not work the same way you would in Excel. The script should run everytime the Excel document is opened b/c of the embedded Word though.

by michael.weintraub

Hi. If I want to access the word object embedded in an excel worksheet, how do I find it? ThisWorkbook.Worksheets("mysheet").Range("myWdDoc") isn't it.

Thanks!

This discussion is closed to new replies.