[Roy]

I have created a template in word which I call through a VB script from
excel. The excel data is populated in the word every time I run this script.

Everything works fine and the data get populated.

I have a header in the template which is represents one of the fields in the
excel sheet. The header shows the correct linked value for the first 10 pages
but then on shows the variable name instead of the value. I have no idea why
it does that?

can someone help

The code is as follows:
For iCurrentRow = 1 To iLastRow
If ActiveSheet.Range("B" & iCurrentRow) "" Then
sFindText = ActiveSheet.Range("Q" & iCurrentRow)
sReplaceText = ActiveSheet.Range("B" & iCurrentRow)
'FindReplace sFindText, sReplaceText, objWord.Selection
End If
Next iCurrentRow

[Doug Robbins - Word MVP]

Exactly what is it that appears on the 11th and following pages?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"Roy" wrote in message
...
I have created a template in word which I call through a VB script from
excel. The excel data is populated in the word every time I run this
script.

Everything works fine and the data get populated.

I have a header in the template which is represents one of the fields in
the
excel sheet. The header shows the correct linked value for the first 10
pages
but then on shows the variable name instead of the value. I have no idea
why
it does that?

can someone help

The code is as follows:
For iCurrentRow = 1 To iLastRow
If ActiveSheet.Range("B" & iCurrentRow) "" Then
sFindText = ActiveSheet.Range("Q" & iCurrentRow)
sReplaceText = ActiveSheet.Range("B" & iCurrentRow)
'FindReplace sFindText, sReplaceText, objWord.Selection
End If
Next iCurrentRow