Controlling Word 2007 from Another Office Program (in this case, Access)

[LA Lawyer]

I presume that this is a fairly common issue. Using Access 2007, I want to:

1. Determine if MS Word 2007 is running or not. If it is open, I want to
open a new document so that I can run some Word code. If Word is not open,
I want to open it and do my thing. I do NOT need the user to see this being
done, especially if it slows down the process.

2. Once I am done, I want to return Word to its prior state.

How is this done?

 

[Jay Freedman]

Look at http://word.mvps.org/FAQs/InterDev/ControlWordFromXL.htm. The code
is exactly the same regardless of which Office program is running the macro,
whether Excel or Access.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.