Prev: I have a document in Word 2007 that will not keep the highlights.
Next: copy music cd onto my own cd
From: s on 2 Jun 2010 11:33
I have a macro which can read the last cell/column of all tables in a
Word 2003/2007 document and store the data in an MS-Access table. But,
some Word documents have the data in structures like a table format
but are not actually tables. The structure looks like a table, but the
table borders are actually line connectors. These documents were
created by a software(VeryPDF PDF to Word converter) which converted
the PDF documents(the original format these documents were) into Word
documents.

1. Is there a way I can convert/replace the tabular structures with
actual tables in Word so that I can use the macro?

2. Or, is there a way I can read the value of the last column from the
tabular structures using some VBA code?

Any advice would be appreciated.

From: Jay Freedman on 2 Jun 2010 16:26
Select the tabular structure and click Table > Convert > Text to Table (or
in Word 2007, Insert > Table > Convert Text to Table).

Before you can get this to work properly, you may have to do some cleanup to
remove some of the line-drawing characters, especially those that make the
corners and the horizontal lines. Instead of removing the vertical lines
between the columns, use those as the "separator characters" in the
conversion dialog.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

s wrote:
> I have a macro which can read the last cell/column of all tables in a
> Word 2003/2007 document and store the data in an MS-Access table. But,
> some Word documents have the data in structures like a table format
> but are not actually tables. The structure looks like a table, but the
> table borders are actually line connectors. These documents were
> created by a software(VeryPDF PDF to Word converter) which converted
> the PDF documents(the original format these documents were) into Word
> documents.
>
> 1. Is there a way I can convert/replace the tabular structures with
> actual tables in Word so that I can use the macro?
>
> 2. Or, is there a way I can read the value of the last column from the
> tabular structures using some VBA code?
>
> Any advice would be appreciated.


From: s on 2 Jun 2010 17:25
On Jun 2, 4:26 pm, "Jay Freedman" <jay.freed...(a)verizon.net> wrote:
> Select the tabular structure and click Table > Convert > Text to Table (or
> in Word 2007, Insert > Table > Convert Text to Table).
>
> Before you can get this to work properly, you may have to do some cleanup to
> remove some of the line-drawing characters, especially those that make the
> corners and the horizontal lines. Instead of removing the vertical lines
> between the columns, use those as the "separator characters" in the
> conversion dialog.
>
> --
> Regards,
> Jay Freedman
> Microsoft Word MVP        FAQ:http://word.mvps.org

Thanks for the suggestion.

How do I use the vertical lines between the columns as "separator
characters"? In Word 2007, I choose Insert -> Table -> Convert Text to
Table, in that at Separate Text as option, I can enter some
information for Other, but what do I enter for the vertical lines
which are actually line connectors? Do I enter their ASCII code
value(i don't know how to find their ASCII code value) or something
else?

Can you please clarify?

Thanks
From: Doug Robbins - Word MVP on 2 Jun 2010 18:57
You could try copying and pasting one of the "line connectors" into the
Other space

--
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, originally posted via msnews.microsoft.com

"s" <s(a)mailinator.com> wrote in message
news:95432408-4b9a-4333-908a-ae4a75c76f75(a)c22g2000vbb.googlegroups.com...
> On Jun 2, 4:26 pm, "Jay Freedman" <jay.freed...(a)verizon.net> wrote:
>> Select the tabular structure and click Table > Convert > Text to Table
>> (or
>> in Word 2007, Insert > Table > Convert Text to Table).
>>
>> Before you can get this to work properly, you may have to do some cleanup
>> to
>> remove some of the line-drawing characters, especially those that make
>> the
>> corners and the horizontal lines. Instead of removing the vertical lines
>> between the columns, use those as the "separator characters" in the
>> conversion dialog.
>>
>> --
>> Regards,
>> Jay Freedman
>> Microsoft Word MVP FAQ:http://word.mvps.org
>
> Thanks for the suggestion.
>
> How do I use the vertical lines between the columns as "separator
> characters"? In Word 2007, I choose Insert -> Table -> Convert Text to
> Table, in that at Separate Text as option, I can enter some
> information for Other, but what do I enter for the vertical lines
> which are actually line connectors? Do I enter their ASCII code
> value(i don't know how to find their ASCII code value) or something
> else?
>
> Can you please clarify?
>
> Thanks

From: Jay Freedman on 2 Jun 2010 21:04
Hint: With the cursor in the Other box, press Ctrl+V to paste the
clipboard content. (Lots of people think they have to use a toolbar
button or a menu entry to paste, and those aren't available in a
dialog. The keyboard shortcut works almost everywhere.)

On Thu, 3 Jun 2010 08:57:47 +1000, "Doug Robbins - Word MVP"
<dkr(a)REMOVECAPSmvps.org> wrote:

>You could try copying and pasting one of the "line connectors" into the
>Other space
>
>--
>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, originally posted via msnews.microsoft.com
>
>"s" <s(a)mailinator.com> wrote in message
>news:95432408-4b9a-4333-908a-ae4a75c76f75(a)c22g2000vbb.googlegroups.com...
>> On Jun 2, 4:26 pm, "Jay Freedman" <jay.freed...(a)verizon.net> wrote:
>>> Select the tabular structure and click Table > Convert > Text to Table
>>> (or
>>> in Word 2007, Insert > Table > Convert Text to Table).
>>>
>>> Before you can get this to work properly, you may have to do some cleanup
>>> to
>>> remove some of the line-drawing characters, especially those that make
>>> the
>>> corners and the horizontal lines. Instead of removing the vertical lines
>>> between the columns, use those as the "separator characters" in the
>>> conversion dialog.
>>>
>>> --
>>> Regards,
>>> Jay Freedman
>>> Microsoft Word MVP FAQ:http://word.mvps.org
>>
>> Thanks for the suggestion.
>>
>> How do I use the vertical lines between the columns as "separator
>> characters"? In Word 2007, I choose Insert -> Table -> Convert Text to
>> Table, in that at Separate Text as option, I can enter some
>> information for Other, but what do I enter for the vertical lines
>> which are actually line connectors? Do I enter their ASCII code
>> value(i don't know how to find their ASCII code value) or something
>> else?
>>
>> Can you please clarify?
>>
>> Thanks
 |  Next  |  Last
Pages: 1 2
Prev: I have a document in Word 2007 that will not keep the highlights.
Next: copy music cd onto my own cd