LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Converting a Word doc to a multi-column Excel spreadsheet

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting irregular Word table to spreadsheet Howard Excel Discussion (Misc queries) 3 April 25th 10 05:37 PM
Need Excel count of 1 word if found in multi-word cells of column Function_Challenged Excel Worksheet Functions 1 August 27th 09 12:08 AM
Converting a Word doc to a multi-column Excel spreadsheet DD Pgh Excel Worksheet Functions 0 January 12th 09 06:42 PM
Converting labels from Word to an Excel spreadsheet Leah Stein New Users to Excel 3 December 20th 06 03:44 AM
How to populate a multi-column activeX listbox on a spreadsheet with an ADO recordset quartz Excel Programming 1 May 3rd 04 10:13 PM


All times are GMT +1. The time now is 06:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"