Word TextBox nightmare

[cjperks]

Hi there

I've been searching for help on this specific problem for a few days now
with no luck so far, so I hope someone here can help me!

At present I'm working with some appallingly designed word documents
that contain masses of data that at present I have to copy out manually


The pages at first appeared to be a collection of tables, so sorting
through them cell by cell looking for the relevant keywords and data was
not that scary a task - however...

The pages are actually a collection of grouped TextBoxes that contain
within them some tables.

I've managed to ungroup/regroup the Textboxes using the
shape.ungroup/regroup commands but trying to extract the tables from the
text boxes seems to be impossible.

I can get the text out of the textbox as a big lump using the
Shapes.AlternativeText but I can't convert this back to a usable table
at present either.

The Shapes.AlternativeText still retains some of the tables formatting
in the form of tab spaces so this might be a way foreward...

Any help would be massively appreciated.


Chris...

 

[Fumei2 via OfficeKB.com]

cross-posted at VBAExpress. Attempting to answer there.

Gerry

will repeat: "The pages are actually a collection of grouped TextBoxes that
contain
within them some tables." UGH! BLEEECH!

"appallingly designed word documents" I'll say...

Although others here may come up with something effective before I do, as I
have to fight against a massive prejudice against textboxes....

Just trying to duplicate the situation makes my skin crawl.

So check both here and VBAExpress.