Converting a Word doc to a multi-column Excel spreadsheet

[DD Pgh]

I have a need to convert a Word doc with properly applied formatting styles
into a multi-column Excel spreadsheet.

I think that this processing would predetermine a format style, like Heading
1, as the row determinator, such that every time the conversion process
encountered content tagged with a Heading 1 format style, the converted
spreadsheet would begin a new row.

This process would then identify the various format styles utilized between
each Heading 1, and convert the content for those styles into the columns
associated with the row of the Heading 1 which they followed.

In other words, treating Excel as a database, the content tagged with a
Heading 1 format style would become the record key (in column A), and the
content associated with each format style following the first Heading 1 and
before the next Heading 1 would convert to become fields associated with the
first Heading 1 (in columns B, C, D, etc.).

I understand that this process would require a rigid application of format
styles, but that is the case for my situation.

I would appreciate any feedback on the topic. Does a vbscript exist for
such a task, or could one be written?

Thank you.

[Doug Robbins - Word MVP]

I am not really sure what you are starting with and what you want to end up
with, but if the document contains Legal Numbered (1, 1.1, 1.1.1 style
numbering, I would use the ConvertNumberstoText command to convert the
numbers to text and then starting with the lowest level numbering (1.1.1
from the above) use a find and replace routine to preface each paragraph
with the appropriate number of tab spaces, then convert the document to a
table which would have the Heading 1s in column 1, the Heading 2s in column
2 and the Heading 3s in column 3, etc. Then copy and paste that table in to
Excel.
--
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

Post by DD Pgh
I have a need to convert a Word doc with properly applied formatting styles
into a multi-column Excel spreadsheet.
I think that this processing would predetermine a format style, like Heading
1, as the row determinator, such that every time the conversion process
encountered content tagged with a Heading 1 format style, the converted
spreadsheet would begin a new row.
This process would then identify the various format styles utilized between
each Heading 1, and convert the content for those styles into the columns
associated with the row of the Heading 1 which they followed.
In other words, treating Excel as a database, the content tagged with a
Heading 1 format style would become the record key (in column A), and the
content associated with each format style following the first Heading 1 and
before the next Heading 1 would convert to become fields associated with the
first Heading 1 (in columns B, C, D, etc.).
I understand that this process would require a rigid application of format
styles, but that is the case for my situation.
I would appreciate any feedback on the topic. Does a vbscript exist for
such a task, or could one be written?
Thank you.