Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting irregular Word table to spreadsheet | Excel Discussion (Misc queries) | |||
Need Excel count of 1 word if found in multi-word cells of column | Excel Worksheet Functions | |||
Converting a Word doc to a multi-column Excel spreadsheet | Excel Worksheet Functions | |||
Converting labels from Word to an Excel spreadsheet | New Users to Excel | |||
How to populate a multi-column activeX listbox on a spreadsheet with an ADO recordset | Excel Programming |