Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / August 2007

Tip: Looking for answers? Try searching our database.

open doc for edit

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Curt - 21 Aug 2007 21:00 GMT
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
Jean-Guy Marcil - 21 Aug 2007 23:05 GMT
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
[quoted text clipped - 15 lines]
>    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.

Signature

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org

Curt - 22 Aug 2007 01:54 GMT
Thank you for steering me in the right direction. It is greatly appreciated
Thanks Again

> Curt was telling us:
> Curt nous racontait que :
[quoted text clipped - 26 lines]
> 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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.