| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Write to Word Document from Excel VBA Help Needed
Just what I needed to know -- thanks so much
"Helmut Weber" wrote: Hi Judy, see: http://word.mvps.org/faqs/interdev/c...wordfromxl.htm http://word.mvps.org/faqs/interdev/E...ateBinding.htm plus have a look at this one: Private Sub Test0000() Dim oWrd As Word.Application Dim oDcm As Word.Document Dim fntName As String fntName = activecell.Font.Name On Error Resume Next Set oWrd = GetObject(, "Word.application") If Err Then Set oWrd = New Word.Application End If oWrd.Visible = True Set oDcm = oWrd.Documents.Add oDcm.Range.InsertBefore "abcdefghi" & Chr(13) oDcm.Range.Paragraphs(1).Range.Font.Name = "Arial" ' ....... some more End Sub -- Greetings from Bavaria, Germany Helmut Weber, MVP WordVBA Win XP, Office 2003 "red.sys" & Chr$(64) & "t-online.de" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert an Excel document to a Word Document | Setting up and Configuration of Excel | |||
| change excel document into word document | Excel Discussion (Misc queries) | |||
| convert excel document to word document (not a picture) | Excel Discussion (Misc queries) | |||
| How do I convert a word document into a Excel document | Excel Discussion (Misc queries) | |||
| How do I convert Word document into an Excel document? | Excel Discussion (Misc queries) | |||
Threaded Mode
