Opening a Microsoft Word 2003 Document.

F

Fello

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

Gary''s Student

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
 
M

MyVeryOwnSelf

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.
Click to expand...

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

Fello

Gary''s Student said:
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
Click to expand...

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

Fello

MyVeryOwnSelf said:
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.
Click to expand...
 
G

Gary''s Student

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