Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing Word from Excel
I want to know more about creating a word document using VBA in Excel.
So far I've come up with this: Private Sub CommandButton1_Click() Dim wrd As Word.Document Application.ActivateMicrosoftApp (xlMicrosoftWord) Set wrd = Word.Application.ActiveDocument With Word.Application wrd.Selection.TypeText "HI!" End With End Sub But "ActiveX component can't create object" for this line: Set wrd = Word.Application.ActiveDocument Then I get "Object doesn't support this property or method" for This line: wrd.Selection.TypeText "HI!" Any help is greatly appreciated - Pikus --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Accessing Excel pages using VB | Excel Discussion (Misc queries) | |||
Accessing Favorites in Excel 2003 | Setting up and Configuration of Excel | |||
Accessing Outlook from Excel | Excel Discussion (Misc queries) | |||
How to stop Excel from accessing the net | Excel Programming | |||
Accessing PowerPoint datalabels from excel VBA | Excel Programming |