Automating Word 2003 in Access 2007

[Grem3]

Hiya folks,

Hope you can help someone new to automation... I am writing a document in word from data in Access 2007 but cannot seem to get past first base! I have referenced the Word 12 object library and this is my test code:

Dim WordObj As Object
Set WordObj = New Word.Application

WordObj.Visible = True

Set WordObj = WordObj.Documents.Open("c:\Users\Duncan\Documents\Sunparadise\System\Templates\QuoteHeader.dot")

WordObj.Selection.TypeText "Hello"

Set WordObj = Nothing

I get "object does not support this property or method" on my typetext command. Can anyone tell me why this would be? I am sure it is something obvious but I can find only very limited help...

Ta,

Grem3

 

[orna]

Dim WordObj As Object
Set WordObj = New Word.Application

WordObj.Visible = True
WordObj.Documents.Add Template:=("c:\Users\Duncan\Documents\Sunparadise\System\Templates\QuoteHeader.dot")
WordObj.Selection.TypeText "Hello"

Set WordObj = Nothing

 

[Grem3]

Thanks and DOH!

G.