P
perks
Hi there
I don't like bothering people asking for help, but I think I'm going to g
insane if I don't find a way to sort this soon.
I've been searching for help on this specific problem for a few days now wit
no luck so far, so I hope someone here can help me!
At present I'm working with some appallingly designed word documents tha
contain masses of data that, at present, I have to copy out manually
Ideally I would re-design everything to be more data friendly but I'm no
allowed to - hence these ongoing problems...
The pages at first appeared to be a collection of tables, so sorting throug
them cell by cell looking for the relevant keywords and data was not that scar
a task - however...
The pages are actually a collection of grouped TextBoxes (shapes) that contai
within them some tables.
I've managed to ungroup/regroup the Textboxes using the shape.ungroup/regrou
commands and cycle through each Textbox, but trying to extract the data fro
tables from the text boxes seems to be impossible.
I can get the text out of the textbox as a big lump using th
Shapes.AlternativeText but I can't convert this back to a usable table a
present either.
The Shapes.AlternativeText still retains some of the tables formatting in th
form of tab spaces so this might be a way forward...
I need to keep the layout of the tables at intact as possible to locate result
that lie in cells next to keywords.
Any help would be massively appreciated.
Chris...
I don't like bothering people asking for help, but I think I'm going to g
insane if I don't find a way to sort this soon.
I've been searching for help on this specific problem for a few days now wit
no luck so far, so I hope someone here can help me!
At present I'm working with some appallingly designed word documents tha
contain masses of data that, at present, I have to copy out manually
Ideally I would re-design everything to be more data friendly but I'm no
allowed to - hence these ongoing problems...
The pages at first appeared to be a collection of tables, so sorting throug
them cell by cell looking for the relevant keywords and data was not that scar
a task - however...
The pages are actually a collection of grouped TextBoxes (shapes) that contai
within them some tables.
I've managed to ungroup/regroup the Textboxes using the shape.ungroup/regrou
commands and cycle through each Textbox, but trying to extract the data fro
tables from the text boxes seems to be impossible.
I can get the text out of the textbox as a big lump using th
Shapes.AlternativeText but I can't convert this back to a usable table a
present either.
The Shapes.AlternativeText still retains some of the tables formatting in th
form of tab spaces so this might be a way forward...
I need to keep the layout of the tables at intact as possible to locate result
that lie in cells next to keywords.
Any help would be massively appreciated.
Chris...