Parsing a Word Document using VBA

Hello,
I am using VBA from Access to interogate word documents. The documents have
a specific format but are edited using word - so users have full rights to
modify the document as they wish.

One portion of the document that I need to validate is data in a 3 column
table. Some columns are "gray" and some are "white". I am currently using the
.shading.texture, .shading.backgroundpatterncolor and
.shading.backgroundpatterncolorindex to determine if the cell is gray. Is
there an easy way to tell if a cell is gray (is not clear)?

The color of the cell will determine what action the program performs. Since
the data in the cell may not be correct, just parsing the cell is not a
guarantee of what action to take either.

Bill

Doug
Thu Nov 17 23:14:07 CST 2005

If ActiveDocument.Tables(1).Cell(1, 1).Shading.BackgroundPatternColor =
wdColorGray10 Then
MsgBox "The Cell is shaded"
End If


--
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

"Bill Deibert" <Bill Deibert@discussions.microsoft.com> wrote in message
news:2C91E35F-689D-478A-9E81-89B5268FD487@microsoft.com...
> Hello,
> I am using VBA from Access to interogate word documents. The documents
> have
> a specific format but are edited using word - so users have full rights to
> modify the document as they wish.
>
> One portion of the document that I need to validate is data in a 3 column
> table. Some columns are "gray" and some are "white". I am currently using
> the
> .shading.texture, .shading.backgroundpatterncolor and
> .shading.backgroundpatterncolorindex to determine if the cell is gray. Is
> there an easy way to tell if a cell is gray (is not clear)?
>
> The color of the cell will determine what action the program performs.
> Since
> the data in the cell may not be correct, just parsing the cell is not a
> guarantee of what action to take either.
>
> Bill