LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
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


 
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
Excel (xls) files spontaneously converting to text files Be-jamin Excel Discussion (Misc queries) 0 November 18th 08 05:31 PM
Converting Large XML Files into CSV Files for Excel DaleB Excel Discussion (Misc queries) 0 December 3rd 07 08:17 PM
Converting Adobe files into Excel files sweetsue516 Excel Discussion (Misc queries) 2 March 13th 06 07:05 PM
Difficult to open files in Excel in different countries Simon Jefford Excel Discussion (Misc queries) 1 July 11th 05 12:50 PM
Stop Excel from converting text labels in CSV files to Values Just Want a Label! Excel Discussion (Misc queries) 1 January 11th 05 04:51 PM


All times are GMT +1. The time now is 05:22 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"