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.

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
--
Gary''s Student - gsnu200745


"Fello" wrote:

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.

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.

"Gary''s Student" wrote:

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
--
Gary''s Student - gsnu200745


"Fello" wrote:

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.

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.

"MyVeryOwnSelf" wrote:

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.
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.

The routine assumes that a Word document called:
hello.doc
already exists in the c:\ folder
--
Gary''s Student - gsnu200745


"Fello" wrote:



"Gary''s Student" wrote:

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
--
Gary''s Student - gsnu200745


"Fello" wrote:

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.

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.