Word Bookmark Syntax in Excel VBA

[Dawber]

I am using an Excel spreadsheet to fill in certain bookmarks in a Word document. I am trying to use the following, without success.

Selection.GoTo What:=wdGoToBookmark, Name:="project"
Selection.TypeText Text:="xxx"

Without these lines, the macro operates as expected, opening and closing the Word aplication. However, as soon as this is introduced, I receive an error message (Run-time error 438 - Object does not support this property or method)

Could anybody point out where are I am going wrong?

 

[SkipVought]

Hi,

Instead of Selection, fully quallify the reference using the word applicaiton object, the document object etc.

Did you use the CreateObject method?

Skip,

_[red][/red]

 

[TonyJollans]

Skip is correct - of course

The reason for your error message, though, is that Selection, as coded, refers to the Excel Selection, which does not have a GoTo method.

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association

 

[SkipVought]

Tony,

Maybe someone will listen.

Skip,

_[red][/red]

 

[Dawber]

Skip/Tony, thanks for responding.In answer to your question, I did use the CreateObject method:

Dim wrdApp As Word.Application
Dim wrdDoc As Word.Document
Set wrdApp = CreateObject("Word.Application")
Set wrdDoc = wrdApp.Documents.Open("C:\Test.doc")

So should I be using something along the lines of:

wrdDoc.GoTo What:=wdGoToBookmark, Name:="project"
wrdDoc.TypeText Text:="xxx"

 

[TonyJollans]

Try working directly with the Range, something like ...

[blue]wrdDoc.Bookmarks("project").Range.Text="xxx"[/blue]

.. but be aware that this (as your original idea) will erase the bookmark

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association