View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default Converting text files to Excel - a difficult one

Sarah,

Since most of this has to do with Word, it would probably be a good
idea to ask this in the Word NG.

But first check if the word document contains any bookmarks (it may if
you're lucky = that will greatly simplify it's analysis.


That said.. if it comes from a software package..
it may be possible to use a different output or read the data directly
from the original app's database rather then parse the Word formatted
output.

Check with the software vendor to see if thay have some way of reading
their data directly, or the format they use to store stuff.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


sarah W wrote :

Hi friends

We have a situation where an elementary planning technique
software outputting all its strategic plans in to a word
document. I am trying to conver this in to an excel file
in order to design a database.

The output looks like this( I am giving only thee samples
1.1, 1.2 & 1.3 but the list consisits of 10 -15 plans).

[snap]
My problem is that I do not know the code to seperate out
text strings what I plan to have headers (plan Name),
Priority, purpose etc in to excel columns and list each
description under them in each row.
Can Somebody please tell me a code for this or point me to
an article which will help me to do this.

Thanks

Sarah W