Overwriting text into a Word DOC with VBA

Tutorials Win: Microsoft Windows Forum

This is a multi-part message in MIME format.

------=_NextPart_000_0017_01C4F906.7A391DA0
Content-Type: text/plain;
charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

Hi,

I have a word DOC and I have to automatically replace some text in it =
with other.
The code uses Automation from an Access application to handle the Word =
DOC

Somewhere on a page of the Doc I have a text like this


Categorie A1

=20

Dinsdag 25-01-2005 aanvang 19.00 De Boeg 2=20

&

Woensdag 26-01-2005 aanvang 19.00 De Welvaart 1

=20

=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20
=20

=20

I have the following VBA code to find that part of the doc and populate =
the table

....

cSearchName =3D "Categorie[ ]@" & rsCat!CatNaam & rsCat!PouleNaam
Set myfind =3D oWrdDoc.Content.Find
myfind.MatchWildcards =3D True
myfind.Execute FindText:=3DcSearchName, Forward:=3DTrue
If myfind.Found Then
Set myrange =3D oWrdDoc.Range(myfind.Parent.Start, =
End:=3DoWrdDoc.Range.End)
Set tbl =3D myrange.Tables(1)

.....

And now I know how to populate the table using=20

....
Set rng =3D tbl.Cell(i, j).Range
rng.Text =3D MyValue

However, I don't know how to change the=20

Dinsdag 25-01-2005 aanvang 19.00 De Boeg 2=20

and=20

Woensdag 26-01-2005 aanvang 19.00 De Welvaart 1

The idea is I don't know what text I have to look for, but instead I =
have to replace the text on second and 4'th rows AFTER Categorie A1 =
(title). And on any of those rows, there are two variables who hold the =
value to replace with, one for normal text and one for bold.

As you see, I have to format also the values, to use Times Roman 14 =
normal for the beginning and bold for De Boeg 2=20

Can anyone give me a clue on how to do it?

Thank you

Regards,
Tomas

=20



------=_NextPart_000_0017_01C4F906.7A391DA0
Content-Type: text/html;
charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-2">
<META content=3D"MSHTML 6.00.2900.2523" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I have a word DOC and I have to =
automatically=20
replace some text in it with other.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>The code uses Automation from an Access =
application=20
to handle the Word DOC</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Somewhere on a page of the Doc I have a =
text like=20
this</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; tab-stops: 0cm 28.3pt =
56.6pt 84.9pt 113.2pt 141.5pt 169.8pt 198.1pt 226.4pt 254.7pt 283.0pt =
311.3pt 339.6pt 367.9pt 396.2pt 424.5pt 452.8pt 481.1pt 509.4pt 537.7pt =
566.0pt 594.3pt 622.6pt 650.9pt 679.2pt 707.5pt 735.8pt 764.1pt 792.4pt" =

align=3Dcenter><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 16pt; mso-bidi-font-size: 10.0pt">Categorie <B=20
style=3D"mso-bidi-font-weight: normal">A1</B><?xml:namespace prefix =3D =
o ns =3D=20
"urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></P>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; tab-stops: 0cm 28.3pt =
56.6pt 84.9pt 113.2pt 141.5pt 169.8pt 198.1pt 226.4pt 254.7pt 283.0pt =
311.3pt 339.6pt 367.9pt 396.2pt 424.5pt 452.8pt 481.1pt 509.4pt 537.7pt =
566.0pt 594.3pt 622.6pt 650.9pt 679.2pt 707.5pt 735.8pt 764.1pt 792.4pt" =

align=3Dcenter><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 14pt; mso-bidi-font-size: =
10.0pt"><o:p>&nbsp;</o:p></SPAN></P>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; tab-stops: 0cm 28.3pt =
56.6pt 84.9pt 113.2pt 141.5pt 169.8pt 198.1pt 226.4pt 254.7pt 283.0pt =
311.3pt 339.6pt 367.9pt 396.2pt 424.5pt 452.8pt 481.1pt 509.4pt 537.7pt =
566.0pt 594.3pt 622.6pt 650.9pt 679.2pt 707.5pt 735.8pt 764.1pt 792.4pt" =

align=3Dcenter><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 14pt; mso-bidi-font-size: 10.0pt">Dinsdag 25-01-2005 =
aanvang=20
19.00 <B style=3D"mso-bidi-font-weight: normal">De Boeg 2=20
</B><o:p></o:p></SPAN></P>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; tab-stops: 0cm 28.3pt =
56.6pt 84.9pt 113.2pt 141.5pt 169.8pt 198.1pt 226.4pt 254.7pt 283.0pt =
311.3pt 339.6pt 367.9pt 396.2pt 424.5pt 452.8pt 481.1pt 509.4pt 537.7pt =
566.0pt 594.3pt 622.6pt 650.9pt 679.2pt 707.5pt 735.8pt 764.1pt 792.4pt" =

align=3Dcenter><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 14pt; mso-bidi-font-size: =
10.0pt">&amp;<o:p></o:p></SPAN></P>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; tab-stops: 0cm 28.3pt =
56.6pt 84.9pt 113.2pt 141.5pt 169.8pt 198.1pt 226.4pt 254.7pt 283.0pt =
311.3pt 339.6pt 367.9pt 396.2pt 424.5pt 452.8pt 481.1pt 509.4pt 537.7pt =
566.0pt 594.3pt 622.6pt 650.9pt 679.2pt 707.5pt 735.8pt 764.1pt 792.4pt" =

align=3Dcenter><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 14pt; mso-bidi-font-size: 10.0pt">Woensdag =
26-01-2005 aanvang=20
19.00 <B style=3D"mso-bidi-font-weight: normal">De Welvaart=20
1<o:p></o:p></B></SPAN></P>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; tab-stops: 0cm 28.3pt =
56.6pt 84.9pt 113.2pt 141.5pt 169.8pt 198.1pt 226.4pt 254.7pt 283.0pt =
311.3pt 339.6pt 367.9pt 396.2pt 424.5pt 452.8pt 481.1pt 509.4pt 537.7pt =
566.0pt 594.3pt 622.6pt 650.9pt 679.2pt 707.5pt 735.8pt 764.1pt 792.4pt" =

align=3Dcenter><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 14pt; mso-bidi-font-size: =
10.0pt"><o:p>&nbsp;</o:p></SPAN></P>
<TABLE class=3DMsoNormalTable=20
style=3D"BORDER-RIGHT: medium none; BORDER-TOP: medium none; MARGIN: =
auto auto auto 10.6pt; BORDER-LEFT: medium none; BORDER-BOTTOM: medium =
none; BORDER-COLLAPSE: collapse; mso-table-layout-alt: fixed; =
mso-border-alt: solid windowtext .5pt; mso-padding-alt: 0cm 3.5pt 0cm =
3.5pt; mso-border-insideh: .5pt solid windowtext; mso-border-insidev: =
.5pt solid windowtext"=20
cellSpacing=3D0 cellPadding=3D0 border=3D1>
<TBODY>
<TR style=3D"HEIGHT: 21pt; mso-yfti-irow: 0">
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: =
0cm; BORDER-LEFT: windowtext 1pt solid; WIDTH: 1cm; PADDING-TOP: 0cm; =
BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: =
transparent; mso-border-alt: solid windowtext .5pt"=20
width=3D38>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; tab-stops: 0cm 28.3pt 56.6pt 84.9pt =
113.2pt 141.5pt 169.8pt 198.1pt 226.4pt 254.7pt 283.0pt 311.3pt 339.6pt =
367.9pt 396.2pt 424.5pt 452.8pt 481.1pt 509.4pt 537.7pt 566.0pt 594.3pt =
622.6pt 650.9pt 679.2pt 707.5pt 735.8pt 764.1pt 792.4pt"><SPAN=20
lang=3DNL style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: =
10.0pt"><o:p><FONT=20
face=3DArial=20
=
size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;</FONT></o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: =
0cm; BORDER-LEFT: #ece9d8; WIDTH: 4cm; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt"=20
width=3D151>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; tab-stops: 0cm 28.3pt 56.6pt 84.9pt =
113.2pt 141.5pt 169.8pt 198.1pt 226.4pt 254.7pt 283.0pt 311.3pt 339.6pt =
367.9pt 396.2pt 424.5pt 452.8pt 481.1pt 509.4pt 537.7pt 566.0pt 594.3pt =
622.6pt 650.9pt 679.2pt 707.5pt 735.8pt 764.1pt 792.4pt"><SPAN=20
lang=3DNL style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: =
10.0pt"></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: =
0cm; BORDER-LEFT: #ece9d8; WIDTH: 47.8pt; PADDING-TOP: 0cm; =
BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: =
transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: =
solid windowtext .5pt"=20
width=3D64>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; tab-stops: 0cm 28.3pt 56.6pt 84.9pt =
113.2pt 141.5pt 169.8pt 198.1pt 226.4pt 254.7pt 283.0pt 311.3pt 339.6pt =
367.9pt 396.2pt 424.5pt 452.8pt 481.1pt 509.4pt 537.7pt 566.0pt 594.3pt =
622.6pt 650.9pt 679.2pt 707.5pt 735.8pt 764.1pt 792.4pt"><SPAN=20
lang=3DNL style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: =
10.0pt"></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: =
0cm; BORDER-LEFT: #ece9d8; WIDTH: 47.85pt; PADDING-TOP: 0cm; =
BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: =
transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: =
solid windowtext .5pt"=20
width=3D64>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; tab-stops: 0cm 28.3pt 56.6pt 84.9pt =
113.2pt 141.5pt 169.8pt 198.1pt 226.4pt 254.7pt 283.0pt 311.3pt 339.6pt =
367.9pt 396.2pt 424.5pt 452.8pt 481.1pt 509.4pt 537.7pt 566.0pt 594.3pt =
622.6pt 650.9pt 679.2pt 707.5pt 735.8pt 764.1pt 792.4pt"><SPAN=20
lang=3DNL style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: =
10.0pt"><FONT=20
face=3DArial size=3D2></FONT></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: =
0cm; BORDER-LEFT: #ece9d8; WIDTH: 47.85pt; PADDING-TOP: 0cm; =
BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: =
transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: =
solid windowtext .5pt"=20
width=3D64>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; tab-stops: 0cm 28.3pt 56.6pt 84.9pt =
113.2pt 141.5pt 169.8pt 198.1pt 226.4pt 254.7pt 283.0pt 311.3pt 339.6pt =
367.9pt 396.2pt 424.5pt 452.8pt 481.1pt 509.4pt 537.7pt 566.0pt 594.3pt =
622.6pt 650.9pt 679.2pt 707.5pt 735.8pt 764.1pt 792.4pt"><SPAN=20
lang=3DNL style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: =
10.0pt"><FONT=20
face=3DArial size=3D2></FONT></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: =
0cm; BORDER-LEFT: #ece9d8; WIDTH: 47.85pt; PADDING-TOP: 0cm; =
BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: =
transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: =
solid windowtext .5pt"=20
width=3D64>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; tab-stops: 0cm 28.3pt 56.6pt 84.9pt =
113.2pt 141.5pt 169.8pt 198.1pt 226.4pt 254.7pt 283.0pt 311.3pt 339.6pt =
367.9pt 396.2pt 424.5pt 452.8pt 481.1pt 509.4pt 537.7pt 566.0pt 594.3pt =
622.6pt 650.9pt 679.2pt 707.5pt 735.8pt 764.1pt 792.4pt"><SPAN=20
lang=3DNL style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: =
10.0pt"><FONT=20
face=3DArial size=3D2></FONT></SPAN></P></TD></TR>
<TR style=3D"HEIGHT: 21pt; mso-yfti-irow: 1">
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: windowtext 1pt solid; WIDTH: 1cm; PADDING-TOP: 0cm; =
BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: =
transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: =
solid windowtext .5pt"=20
width=3D38>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt; mso-pagination: =
none"><SPAN=20
lang=3DNL=20
style=3D"FONT-SIZE: 12pt; LAYOUT-GRID-MODE: line; COLOR: black; =
mso-bidi-font-size: 10.0pt"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 4cm; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D151>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt; =
mso-outline-level: 2"><SPAN=20
lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 47.8pt; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D64>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt; =
mso-outline-level: 2"><SPAN=20
lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 47.85pt; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D64>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: right; =
mso-outline-level: 2"=20
align=3Dright><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 47.85pt; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D64>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: right; =
mso-outline-level: 2"=20
align=3Dright><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 47.85pt; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D64>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: right; =
mso-outline-level: 2"=20
align=3Dright><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD></TR>
<TR style=3D"HEIGHT: 21pt; mso-yfti-irow: 2">
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: windowtext 1pt solid; WIDTH: 1cm; PADDING-TOP: 0cm; =
BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: =
transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: =
solid windowtext .5pt"=20
width=3D38>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt; mso-pagination: =
none"><SPAN=20
lang=3DNL=20
style=3D"FONT-SIZE: 12pt; LAYOUT-GRID-MODE: line; COLOR: black; =
mso-bidi-font-size: 10.0pt"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 4cm; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D151>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt; =
mso-outline-level: 2"><SPAN=20
lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 47.8pt; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D64>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt; =
mso-outline-level: 2"><SPAN=20
lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 47.85pt; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D64>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: right; =
mso-outline-level: 2"=20
align=3Dright><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 47.85pt; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D64>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: right; =
mso-outline-level: 2"=20
align=3Dright><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 47.85pt; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D64>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: right; =
mso-outline-level: 2"=20
align=3Dright><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD></TR>
<TR style=3D"HEIGHT: 21pt; mso-yfti-irow: 3">
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: windowtext 1pt solid; WIDTH: 1cm; PADDING-TOP: 0cm; =
BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: =
transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: =
solid windowtext .5pt"=20
width=3D38>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt; mso-pagination: =
none"><SPAN=20
lang=3DNL=20
style=3D"FONT-SIZE: 12pt; LAYOUT-GRID-MODE: line; COLOR: black; =
mso-bidi-font-size: 10.0pt"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 4cm; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D151>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt; =
mso-outline-level: 2"><SPAN=20
lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 47.8pt; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D64>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt; =
mso-outline-level: 2"><SPAN=20
lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 47.85pt; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D64>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: right; =
mso-outline-level: 2"=20
align=3Dright><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 47.85pt; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D64>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: right; =
mso-outline-level: 2"=20
align=3Dright><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 47.85pt; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D64>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: right; =
mso-outline-level: 2"=20
align=3Dright><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD></TR>
<TR style=3D"HEIGHT: 21pt; mso-yfti-irow: 4">
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: windowtext 1pt solid; WIDTH: 1cm; PADDING-TOP: 0cm; =
BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: =
transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: =
solid windowtext .5pt"=20
width=3D38>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt; mso-pagination: =
none"><SPAN=20
lang=3DNL=20
style=3D"FONT-SIZE: 12pt; LAYOUT-GRID-MODE: line; COLOR: black; =
mso-bidi-font-size: 10.0pt"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 4cm; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D151>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt; =
mso-outline-level: 2"><SPAN=20
lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 47.8pt; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D64>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt; =
mso-outline-level: 2"><SPAN=20
lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 47.85pt; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D64>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: right; =
mso-outline-level: 2"=20
align=3Dright><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 47.85pt; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D64>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: right; =
mso-outline-level: 2"=20
align=3Dright><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 47.85pt; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D64>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: right; =
mso-outline-level: 2"=20
align=3Dright><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD></TR>
<TR style=3D"HEIGHT: 21pt; mso-yfti-irow: 5">
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: windowtext 1pt solid; WIDTH: 1cm; PADDING-TOP: 0cm; =
BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: =
transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: =
solid windowtext .5pt"=20
width=3D38>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt; mso-pagination: =
none"><SPAN=20
lang=3DNL=20
style=3D"FONT-SIZE: 12pt; LAYOUT-GRID-MODE: line; COLOR: black; =
mso-bidi-font-size: 10.0pt"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 4cm; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D151>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt; =
mso-outline-level: 2"><SPAN=20
lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 47.8pt; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D64>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt; =
mso-outline-level: 2"><SPAN=20
lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 47.85pt; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D64>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: right; =
mso-outline-level: 2"=20
align=3Dright><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 47.85pt; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D64>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: right; =
mso-outline-level: 2"=20
align=3Dright><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 47.85pt; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D64>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: right; =
mso-outline-level: 2"=20
align=3Dright><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD></TR>
<TR style=3D"HEIGHT: 21pt; mso-yfti-irow: 6; mso-yfti-lastrow: yes">
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: windowtext 1pt solid; WIDTH: 1cm; PADDING-TOP: 0cm; =
BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: =
transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: =
solid windowtext .5pt"=20
width=3D38>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt; mso-pagination: =
none"><SPAN=20
lang=3DNL=20
style=3D"FONT-SIZE: 12pt; LAYOUT-GRID-MODE: line; COLOR: black; =
mso-bidi-font-size: 10.0pt"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 4cm; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D151>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt; =
mso-outline-level: 2"><SPAN=20
lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 47.8pt; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D64>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt; =
mso-outline-level: 2"><SPAN=20
lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 47.85pt; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D64>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: right; =
mso-outline-level: 2"=20
align=3Dright><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 47.85pt; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D64>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: right; =
mso-outline-level: 2"=20
align=3Dright><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD>
<TD=20
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.5pt; =
BORDER-TOP: #ece9d8; PADDING-LEFT: 3.5pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: #ece9d8; WIDTH: 47.85pt; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: transparent; =
mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid =
windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
width=3D64>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: right; =
mso-outline-level: 2"=20
align=3Dright><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p>&nbsp;</o:p></SPAN></P></TD></TR></TBODY></TABLE>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; tab-stops: 0cm 28.3pt =
56.6pt 84.9pt 113.2pt 141.5pt 169.8pt 198.1pt 226.4pt 254.7pt 283.0pt =
311.3pt 339.6pt 367.9pt 396.2pt 424.5pt 452.8pt 481.1pt 509.4pt 537.7pt =
566.0pt 594.3pt 622.6pt 650.9pt 679.2pt 707.5pt 735.8pt 764.1pt 792.4pt" =

align=3Dcenter><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: =
10.0pt"><o:p>&nbsp;</o:p></SPAN></P></DIV>
<DIV><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><o:p><FONT =
face=3DArial=20
size=3D2>I have the following VBA code &nbsp;to find that part of the =
doc and=20
populate the table</FONT></o:p></SPAN></DIV>
<DIV><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><o:p><FONT =
face=3DArial=20
size=3D2></FONT></o:p></SPAN>&nbsp;</DIV>
<DIV>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; tab-stops: 0cm 28.3pt 56.6pt 84.9pt =
113.2pt 141.5pt 169.8pt 198.1pt 226.4pt 254.7pt 283.0pt 311.3pt 339.6pt =
367.9pt 396.2pt 424.5pt 452.8pt 481.1pt 509.4pt 537.7pt 566.0pt 594.3pt =
622.6pt 650.9pt 679.2pt 707.5pt 735.8pt 764.1pt 792.4pt"><SPAN=20
lang=3DNL style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: =
10.0pt"><o:p><FONT=20
face=3DArial size=3D2>....</FONT></o:p></SPAN></P>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; tab-stops: 0cm 28.3pt 56.6pt 84.9pt =
113.2pt 141.5pt 169.8pt 198.1pt 226.4pt 254.7pt 283.0pt 311.3pt 339.6pt =
367.9pt 396.2pt 424.5pt 452.8pt 481.1pt 509.4pt 537.7pt 566.0pt 594.3pt =
622.6pt 650.9pt 679.2pt 707.5pt 735.8pt 764.1pt 792.4pt"><SPAN=20
lang=3DNL style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: =
10.0pt"><o:p><FONT=20
face=3DArial size=3D2>cSearchName =3D "Categorie[ ]@" &amp; =
rsCat!CatNaam &amp;=20
rsCat!PouleNaam<BR></FONT></o:p></SPAN><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><o:p><FONT =
face=3DArial=20
size=3D2>Set myfind =3D oWrdDoc.Content.Find<BR>myfind.MatchWildcards =
=3D=20
True<BR>myfind.Execute FindText:=3DcSearchName, Forward:=3DTrue<BR>If =
myfind.Found=20
Then<BR>&nbsp;&nbsp;&nbsp; Set myrange =3D =
oWrdDoc.Range(myfind.Parent.Start,=20
End:=3DoWrdDoc.Range.End)<BR>&nbsp;&nbsp;&nbsp;&nbsp;Set tbl =3D=20
myrange.Tables(1)</FONT></o:p></SPAN></P><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: =
10.0pt"><o:p></o:p></SPAN></DIV>
<DIV><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><o:p><FONT =
face=3DArial=20
size=3D2>.....</FONT></o:p></SPAN></DIV>
<DIV><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><o:p><FONT =
face=3DArial=20
size=3D2></FONT></o:p></SPAN>&nbsp;</DIV>
<DIV><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><o:p><FONT =
face=3DArial=20
size=3D2>And now I know how to populate the table using =
</FONT></o:p></SPAN></DIV>
<DIV><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><o:p><FONT =
face=3DArial=20
size=3D2></FONT></o:p></SPAN>&nbsp;</DIV>
<DIV><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><o:p><FONT =
face=3DArial=20
size=3D2>....</FONT></o:p></SPAN></DIV>
<DIV><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><o:p><FONT =
face=3DArial=20
size=3D2>Set rng =3D tbl.Cell(i, j).Range<BR>rng.Text =3D=20
MyValue</FONT></o:p></SPAN></DIV>
<DIV><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><o:p><FONT =
face=3DArial=20
size=3D2></FONT></o:p></SPAN>&nbsp;</DIV>
<DIV><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><o:p><FONT =
face=3DArial=20
size=3D2>However, I don't know how to change the </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT></o:p></SPAN><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><o:p><SPAN =
lang=3DNL=20
style=3D"FONT-SIZE: 14pt; mso-bidi-font-size: =
10.0pt"></SPAN></o:p></SPAN>&nbsp;</DIV>
<DIV><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><o:p><SPAN =
lang=3DNL=20
style=3D"FONT-SIZE: 14pt; mso-bidi-font-size: 10.0pt"><FONT face=3DArial =

size=3D2>Dinsdag 25-01-2005 aanvang 19.00 De Boeg 2=20
</FONT></SPAN></o:p></SPAN></DIV>
<DIV><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><o:p><SPAN =
lang=3DNL=20
style=3D"FONT-SIZE: 14pt; mso-bidi-font-size: 10.0pt"><FONT face=3DArial =

size=3D2></FONT></SPAN></o:p></SPAN>&nbsp;</DIV>
<DIV><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><o:p><SPAN =
lang=3DNL=20
style=3D"FONT-SIZE: 14pt; mso-bidi-font-size: 10.0pt"><FONT face=3DArial =
size=3D2>and=20
</FONT></SPAN></o:p></SPAN></DIV>
<DIV><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><o:p><SPAN =
lang=3DNL=20
style=3D"FONT-SIZE: 14pt; mso-bidi-font-size: 10.0pt"><FONT face=3DArial =

size=3D2></FONT></SPAN></o:p></SPAN>&nbsp;</DIV>
<DIV><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><o:p><SPAN =
lang=3DNL=20
style=3D"FONT-SIZE: 14pt; mso-bidi-font-size: 10.0pt"><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 14pt; mso-bidi-font-size: 10.0pt"><FONT face=3DArial =

size=3D2>Woensdag 26-01-2005 aanvang 19.00 De Welvaart=20
1</FONT></SPAN></SPAN></o:p></SPAN></DIV>
<DIV><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><o:p><SPAN =
lang=3DNL=20
style=3D"FONT-SIZE: 14pt; mso-bidi-font-size: 10.0pt"><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 14pt; mso-bidi-font-size: 10.0pt"><FONT face=3DArial =

size=3D2></FONT></SPAN></SPAN></o:p></SPAN>&nbsp;</DIV>
<DIV><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><o:p><SPAN =
lang=3DNL=20
style=3D"FONT-SIZE: 14pt; mso-bidi-font-size: 10.0pt"><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 14pt; mso-bidi-font-size: 10.0pt"><FONT =
face=3DArial><FONT=20
size=3D2>The idea is I don't know what text I have to look for, but =
instead I have=20
to replace the text on second and 4'th rows AFTER <SPAN lang=3DNL=20
style=3D"FONT-SIZE: 16pt; mso-bidi-font-size: 10.0pt">Categorie A1 <FONT =

size=3D2>(title). And on any of those rows, there are two variables who =
hold the=20
value to replace with, one for normal text and one for=20
bold.<o:p></o:p></FONT></SPAN></FONT></FONT></SPAN></SPAN></o:p></SPAN></=
DIV>
<DIV><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><o:p><SPAN =
lang=3DNL=20
style=3D"FONT-SIZE: 14pt; mso-bidi-font-size: 10.0pt"><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 14pt; mso-bidi-font-size: 10.0pt"><FONT face=3DArial =

size=3D2></FONT></SPAN></SPAN></o:p></SPAN>&nbsp;</DIV>
<DIV><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><o:p><SPAN =
lang=3DNL=20
style=3D"FONT-SIZE: 14pt; mso-bidi-font-size: 10.0pt"><FONT =
face=3DArial><FONT=20
size=3D2><SPAN lang=3DNL style=3D"FONT-SIZE: 14pt; mso-bidi-font-size: =
10.0pt"><FONT=20
face=3D"Times New Roman"></FONT><o:p></o:p></SPAN><o:p>As you see, I =
have to=20
format also the values, to use Times Roman 14 normal for the beginning =
and bold=20
for De Boeg 2 </o:p></FONT></FONT></SPAN></o:p></SPAN></DIV>
<DIV><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><o:p><SPAN =
lang=3DNL=20
style=3D"FONT-SIZE: 14pt; mso-bidi-font-size: 10.0pt"><FONT =
face=3DArial><FONT=20
size=3D2><o:p></o:p></FONT></FONT></SPAN></o:p></SPAN>&nbsp;</DIV>
<DIV><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><o:p><SPAN =
lang=3DNL=20
style=3D"FONT-SIZE: 14pt; mso-bidi-font-size: 10.0pt"><FONT =
face=3DArial><FONT=20
size=3D2><o:p>Can anyone give me a clue on how to do=20
it?</o:p></FONT></FONT></SPAN></o:p></SPAN></DIV>
<DIV><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><o:p><SPAN =
lang=3DNL=20
style=3D"FONT-SIZE: 14pt; mso-bidi-font-size: 10.0pt"><FONT =
face=3DArial><FONT=20
size=3D2><o:p></o:p></FONT></FONT></SPAN></o:p></SPAN>&nbsp;</DIV>
<DIV><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><o:p><SPAN =
lang=3DNL=20
style=3D"FONT-SIZE: 14pt; mso-bidi-font-size: 10.0pt"><FONT =
face=3DArial><FONT=20
size=3D2><o:p>Thank you</o:p></FONT></FONT></SPAN></o:p></SPAN></DIV>
<DIV><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><o:p><SPAN =
lang=3DNL=20
style=3D"FONT-SIZE: 14pt; mso-bidi-font-size: 10.0pt"><FONT =
face=3DArial><FONT=20
size=3D2><o:p></o:p></FONT></FONT></SPAN></o:p></SPAN>&nbsp;</DIV>
<DIV><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><o:p><SPAN =
lang=3DNL=20
style=3D"FONT-SIZE: 14pt; mso-bidi-font-size: 10.0pt"><FONT =
face=3DArial><FONT=20
size=3D2><o:p>Regards,</o:p></FONT></FONT></SPAN></o:p></SPAN></DIV>
<DIV><SPAN lang=3DNL=20
style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><o:p><SPAN =
lang=3DNL=20
style=3D"FONT-SIZE: 14pt; mso-bidi-font-size: 10.0pt"><FONT =
face=3DArial><FONT=20
size=3D2><o:p>Tomas</o:p></FONT></FONT></SPAN></DIV>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; tab-stops: 0cm 28.3pt 56.6pt 84.9pt =
113.2pt 141.5pt 169.8pt 198.1pt 226.4pt 254.7pt 283.0pt 311.3pt 339.6pt =
367.9pt 396.2pt 424.5pt 452.8pt 481.1pt 509.4pt 537.7pt 566.0pt 594.3pt =
622.6pt 650.9pt 679.2pt 707.5pt 735.8pt 764.1pt 792.4pt"><FONT=20
face=3DArial size=3D2></FONT><FONT face=3DArial =
size=3D2></FONT><BR><FONT face=3DArial=20
size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;=20
</FONT></o:p></SPAN></P>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0cm 0cm 0pt; tab-stops: 0cm 28.3pt 56.6pt 84.9pt =
113.2pt 141.5pt 169.8pt 198.1pt 226.4pt 254.7pt 283.0pt 311.3pt 339.6pt =
367.9pt 396.2pt 424.5pt 452.8pt 481.1pt 509.4pt 537.7pt 566.0pt 594.3pt =
622.6pt 650.9pt 679.2pt 707.5pt 735.8pt 764.1pt 792.4pt"><SPAN=20
lang=3DNL style=3D"FONT-SIZE: 12pt; mso-bidi-font-size: =
10.0pt"><o:p><FONT=20
face=3DArial size=3D2></FONT></o:p></SPAN>&nbsp;</P></BODY></HTML>

------=_NextPart_000_0017_01C4F906.7A391DA0--
Top

Re: Overwriting text into a Word DOC with VBA by Jezebel

Jezebel
Wed Jan 12 18:07:26 CST 2005

If your document is strictly formatted -- which your description implies --
a much simpler approach is to use document properties and DocProperty
fields. Set up the document/template in advance with DocProperty fields for
the pieces of information you need to insert. The in your VBA code, all you
need do is redefine the property and update fields.



"NWx" <test@test.com> wrote in message
news:egB7MXP%23EHA.3260@TK2MSFTNGP14.phx.gbl...
Hi,

I have a word DOC and I have to automatically replace some text in it with
other.
The code uses Automation from an Access application to handle the Word DOC

Somewhere on a page of the Doc I have a text like this


Categorie A1

Dinsdag 25-01-2005 aanvang 19.00 De Boeg 2
&
Woensdag 26-01-2005 aanvang 19.00 De Welvaart 1










I have the following VBA code to find that part of the doc and populate the
table

....
cSearchName = "Categorie[ ]@" & rsCat!CatNaam & rsCat!PouleNaam
Set myfind = oWrdDoc.Content.Find
myfind.MatchWildcards = True
myfind.Execute FindText:=cSearchName, Forward:=True
If myfind.Found Then
Set myrange = oWrdDoc.Range(myfind.Parent.Start, End:=oWrdDoc.Range.End)
Set tbl = myrange.Tables(1)
.....

And now I know how to populate the table using

....
Set rng = tbl.Cell(i, j).Range
rng.Text = MyValue

However, I don't know how to change the

Dinsdag 25-01-2005 aanvang 19.00 De Boeg 2

and

Woensdag 26-01-2005 aanvang 19.00 De Welvaart 1

The idea is I don't know what text I have to look for, but instead I have to
replace the text on second and 4'th rows AFTER Categorie A1 (title). And on
any of those rows, there are two variables who hold the value to replace
with, one for normal text and one for bold.

As you see, I have to format also the values, to use Times Roman 14 normal
for the beginning and bold for De Boeg 2

Can anyone give me a clue on how to do it?

Thank you

Regards,
Tomas





Top

Re: Overwriting text into a Word DOC with VBA by NWx

NWx
Thu Jan 13 06:34:15 CST 2005

Thanks for reply

But I'd like to know, how can I select a certain text line in a range object
(line 2 and 4 in my case). Then know how to replace all text in the range
with other text

Regards


"Jezebel" <madbastard@whitehouse.gov> wrote in message
news:%23C%237ePQ%23EHA.3840@tk2msftngp13.phx.gbl...
> If your document is strictly formatted -- which your description
> implies --
> a much simpler approach is to use document properties and DocProperty
> fields. Set up the document/template in advance with DocProperty fields
> for
> the pieces of information you need to insert. The in your VBA code, all
> you
> need do is redefine the property and update fields.
>
>
>
> "NWx" <test@test.com> wrote in message
> news:egB7MXP%23EHA.3260@TK2MSFTNGP14.phx.gbl...
> Hi,
>
> I have a word DOC and I have to automatically replace some text in it with
> other.
> The code uses Automation from an Access application to handle the Word DOC
>
> Somewhere on a page of the Doc I have a text like this
>
>
> Categorie A1
>
> Dinsdag 25-01-2005 aanvang 19.00 De Boeg 2
> &
> Woensdag 26-01-2005 aanvang 19.00 De Welvaart 1
>
>
>
>
>
>
>
>
>
>
> I have the following VBA code to find that part of the doc and populate
> the
> table
>
> ....
> cSearchName = "Categorie[ ]@" & rsCat!CatNaam & rsCat!PouleNaam
> Set myfind = oWrdDoc.Content.Find
> myfind.MatchWildcards = True
> myfind.Execute FindText:=cSearchName, Forward:=True
> If myfind.Found Then
> Set myrange = oWrdDoc.Range(myfind.Parent.Start,
> End:=oWrdDoc.Range.End)
> Set tbl = myrange.Tables(1)
> .....
>
> And now I know how to populate the table using
>
> ....
> Set rng = tbl.Cell(i, j).Range
> rng.Text = MyValue
>
> However, I don't know how to change the
>
> Dinsdag 25-01-2005 aanvang 19.00 De Boeg 2
>
> and
>
> Woensdag 26-01-2005 aanvang 19.00 De Welvaart 1
>
> The idea is I don't know what text I have to look for, but instead I have
> to
> replace the text on second and 4'th rows AFTER Categorie A1 (title). And
> on
> any of those rows, there are two variables who hold the value to replace
> with, one for normal text and one for bold.
>
> As you see, I have to format also the values, to use Times Roman 14 normal
> for the beginning and bold for De Boeg 2
>
> Can anyone give me a clue on how to do it?
>
> Thank you
>
> Regards,
> Tomas
>
>
>
>
>


Top

Re: Overwriting text into a Word DOC with VBA by Jean-Guy

Jean-Guy
Thu Jan 13 08:55:08 CST 2005

NWx was telling us:
NWx nous racontait que :

> Thanks for reply
>
> But I'd like to know, how can I select a certain text line in a range
> object (line 2 and 4 in my case). Then know how to replace all text
> in the range with other text
>

If your "lines" are in fact paragraphs (delimited by ¶) then all you need
is:
(Let's say the range object name is MyRange)

Dim Line2Range as Range
Dim Line4Range as Range

Set Line2Range = MyRange.Paragraphs(2).Range
and
Set Line4Range = MyRange.Paragraphs(4).Range

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org



Top

Re: Overwriting text into a Word DOC with VBA by NWx

NWx
Thu Jan 13 14:30:58 CST 2005

Hi,

Thank you for your reply.
I'll test this and hope it will work.

Best regards

"Jean-Guy Marcil" <no-spam@leaveme.alone> wrote in message
news:OYMLh$X%23EHA.824@TK2MSFTNGP11.phx.gbl...
> NWx was telling us:
> NWx nous racontait que :
>
>> Thanks for reply
>>
>> But I'd like to know, how can I select a certain text line in a range
>> object (line 2 and 4 in my case). Then know how to replace all text
>> in the range with other text
>>
>
> If your "lines" are in fact paragraphs (delimited by ¶) then all you need
> is:
> (Let's say the range object name is MyRange)
>
> Dim Line2Range as Range
> Dim Line4Range as Range
>
> Set Line2Range = MyRange.Paragraphs(2).Range
> and
> Set Line4Range = MyRange.Paragraphs(4).Range
>
> --
> Salut!
> _______________________________________
> Jean-Guy Marcil - Word MVP
> jmarcilREMOVE@CAPSsympatico.caTHISTOO
> Word MVP site: http://www.word.mvps.org
>
>
>


Top