Prev: mailmerge execute
Next: Error accessing XML Node
From: cjperks on 29 Apr 2010 05:18

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


--
cjperks
------------------------------------------------------------------------
cjperks's Profile: http://www.thecodecage.com/forumz/member.php?u=1817
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=199421

http://www.thecodecage.com/forumz

From: Fumei2 via OfficeKB.com on 29 Apr 2010 17:32
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.



cjperks wrote:
>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...
>

--
Gerry

Message posted via http://www.officekb.com

 | 
Pages: 1
Prev: mailmerge execute
Next: Error accessing XML Node