Opening a Microsoft Word 2003 Document.
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. |
Opening a Microsoft Word 2003 Document.
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. |
Opening a Microsoft Word 2003 Document.
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. |
Opening a Microsoft Word 2003 Document.
"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. |
Opening a Microsoft Word 2003 Document.
"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. |
Opening a Microsoft Word 2003 Document.
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. |
All times are GMT +1. The time now is 08:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com