Opening a Microsoft Word 2003 Document.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fello - 17 Sep 2007 17:24 GMT

I am trying to write a macro that opens a Microsoft word 2003 document so
that I can transfer an Excel address worksheet to it in order to make address
labels. My problem is that the macro won't "recognize" the Word format.

Reply to this Message

Gary''s Student - 17 Sep 2007 20:00 GMT

If you want to open an existing word doc, then something like:

Sub Macro1()
x = Shell("cmd.exe /c C:\hello.doc", 1)
End Sub

should work

Signature

Gary''s Student - gsnu200745

> I am trying to write a macro that opens a Microsoft word 2003 document so
> that I can transfer an Excel address worksheet to it in order to make address
> labels. My problem is that the macro won't "recognize" the Word format.

Reply to this Message

Fello - 17 Sep 2007 20:38 GMT

> If you want to open an existing word doc, then something like:
>
[quoted text clipped - 7 lines]
> > that I can transfer an Excel address worksheet to it in order to make address
> > labels. My problem is that the macro won't "recognize" the Word format.

Thanks for your help. I tried this routine: x = Shell("cmd.exe /c
C:\hello.doc", 1) and it only seems to open and close MSDOS briefly, then
nothing else happens.

Reply to this Message

Gary''s Student - 17 Sep 2007 21:00 GMT

The routine assumes that a Word document called:
hello.doc
already exists in the c:\ folder

Signature

Gary''s Student - gsnu200745

> > If you want to open an existing word doc, then something like:
> >
[quoted text clipped - 11 lines]
> C:\hello.doc", 1) and it only seems to open and close MSDOS briefly, then
> nothing else happens.

Reply to this Message

MyVeryOwnSelf - 17 Sep 2007 20:34 GMT

> I am trying to write a macro that opens a Microsoft word 2003 document
> so that I can transfer an Excel address worksheet to it in order to
> make address labels. My problem is that the macro won't "recognize"
> the Word format.

Forgive the digression if you've already considered this, but a
straightforward way to make address labels from an Excel address worksheet
is Word's "Mail Merge" feature.

Reply to this Message

Fello - 17 Sep 2007 20:42 GMT

> > I am trying to write a macro that opens a Microsoft word 2003 document
> > so that I can transfer an Excel address worksheet to it in order to
[quoted text clipped - 5 lines]
> is Word's "Mail Merge" feature.
> Thanks. I am using the word\mail merge feature; my problem is writing a macro that will open the word document so I can use it.

Reply to this Message