open doc for edit

C

Curt

Want to open letterhead.doc for user input then send to printer. Have the
following used for mail merge fine. Opens the doc then closes it Can someone
insert what I need so user may edit then print before close
Thanks Much

Private Sub optionbutton7_Click()
'Open Thank You Letter
OptionButton7.Value = False
Dim Word As New Word.Application
Dim WordDoc As New Word.Document
Word.Visible = True
Set WordDoc = Word.Documents.Open("C:\parade\Letterhead.doc")
With WordDoc


End With
Word.Application.Quit
Set Word = Nothing
End Sub
 
J

Jean-Guy Marcil

Curt was telling us:
Curt nous racontait que :
Want to open letterhead.doc for user input then send to printer. Have
the following used for mail merge fine. Opens the doc then closes it
Can someone insert what I need so user may edit then print before
close
Thanks Much

Private Sub optionbutton7_Click()
'Open Thank You Letter
OptionButton7.Value = False
Dim Word As New Word.Application
Dim WordDoc As New Word.Document
Word.Visible = True
Set WordDoc = Word.Documents.Open("C:\parade\Letterhead.doc")
With WordDoc


End With
Word.Application.Quit
Set Word = Nothing
End Sub

If you want a single Sub to do all this, you will need a userform to prompt
the user to type the various bits of text that re needed and then insert
these bits of text by code. This means that user formatting will be
difficult.

If you want the user to edit the document itself, the normal way; you will
need a second sub to do the printing and the closing.


--

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org
 
C

Curt

Thank you for steering me in the right direction. It is greatly appreciated
Thanks Again
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top