View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jimbob Jimbob is offline
external usenet poster
 
Posts: 48
Default Macro copying an array and pasting to a Word bookmark

Helmut GrĂ¼ss from Lincolnshire.
Thanks for your response I have been away since you posted but I'll try this
tomorrow.
Thanks again
Jimbob

"Helmut Weber" wrote:

Hi Jimbob,

apart form other issues,
which will be addressed in the next question, IMHO,

Dim wrdApp As Word.Application


alone is not sufficient.

There has to be 'getobject' or 'createobject' in addition,
like for an already running instance of Word:

Dim wrdApp As Word.Application
set wrdApp = getobject(, "Word.Application")

With wrdDoc
Dim BmkNm As String
BmkNm = "S1"
End With


Doesn't affect Word at all.

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"