Re: Dealing with Tables in VBA

OK, I am going to assume that they are checkbox formfields. However, a bit
of clarification of the following would help:

Find the text in the second column of each row "No Filter Required". That
string is always the last line of the cell. If the checkbox just to the
left
of, and on the same last line as, that string within the cell is checked,
then do nothing and go to the next row. If there's something there, copy
everything else in the cell (except for that last line) to an Excel
spread*** where I'll deal with it later.

1. Is it correct that the checkbox and the text "No Filter Required" are
in the same cell of the table?

2. If the answer to 1 is "Yes", are the checkbox and the text "No Filter
Required" in a paragraph by themselves. That is, if you click on the
Show/Hide (¶) button, is the line before the line containing the checkbox
terminated with a ¶?

3 What do you mean by "If there's something there"? Exactly where is
"there"? Are we now talking about something being in the second column of
the next row of the table? And, which cell is it for which everything but
the last line should be copied. Are we now talking about the cell that
contains the checkbox and the text "No Filter Required"?


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

"Budget Programmer" <BudgetProgrammer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:DDB77AB5-12B0-4DBC-A0E5-A59D140B8B27@xxxxxxxxxxxxxxxx
Hi,
When I click on the Checkbox, the border on the resulting dialogue box
says
"Check Box Form Field Options". There is no Bookmark, and the checkbox is
enabled.
Many Thanks
--
Programmer on Budget


"Doug Robbins - Word MVP" wrote:

What type of checkbox is it? A checkbox formfield as used in a protected
document or something else?

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

"Budget Programmer" <BudgetProgrammer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:90653287-4540-474B-AF42-C51DF2582C91@xxxxxxxxxxxxxxxx
I have a lot of experience with Excel VBA, but don't know much about
Word
VBA. Here's what I'd like to do:

Find a occurance of a text string "Data Filter Requirements" after the
table
of contents. (If I have to find the second occurance of it, that's
fine).
After that text, there are a variable number of tables. Within each
table,
I'd like to:
Find the text in the second column of each row "No Filter Required".
That
string is always the last line of the cell. If the checkbox just to
the
left
of, and on the same last line as, that string within the cell is
checked,
then do nothing and go to the next row. If there's something there,
copy
everything else in the cell (except for that last line) to an Excel
spread*** where I'll deal with it later.
I'd like to loop through every row (variable number of rows) in every
table
(variable number of tables). I'd appreciate any help you could give.
I just don't know how to search for a table, determine how many rows
there
are, how many tables there are, find a checkbox, select only the last
line
of
text in a cell, etc.
Many Thanks.





.