Using Application.ActivateMicrosoftApp xlMicrosoftWord

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

billw1829 - 04 Apr 2006 21:40 GMT

I'm launching MS Word from Excel and was wondering if there are any arguments
that can be used in the Application.ActivateMicrosoftApp xlMicrosoftWord
expression to automatically execute a letter merge whose form letter and
merge file are already known (and populated).

Am a fair Excel VB programmer but have no experience at all programming Word.
Any tips and/or hints to perform this function will be appreciated.

Thank you -
Bill Wachtenheim
Marlborough, MA

Reply to this Message

Jean-Guy Marcil - 05 Apr 2006 02:39 GMT

billw1829 was telling us:
billw1829 nous racontait que :

> I'm launching MS Word from Excel and was wondering if there are any
> arguments that can be used in the Application.ActivateMicrosoftApp
[quoted text clipped - 4 lines]
> programming Word. Any tips and/or hints to perform this function will
> be appreciated.

No, I don't think you can have argument in the Activate line that foes that.
In fact, Activate does not take any arguments.

What you can do is start the macro recorder, do the mail merge and then
examine the code you get to clean it up.
For pointers on that, see:
http://word.mvps.org/faqs/macrosvba/UsingRecorder.htm
and
http://word.mvps.org/faqs/macrosvba/ModifyRecordedMacro.htm

Signature

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org

Reply to this Message