rtf extraction to excel

I have an rtf doc and would like to extract the information into an excel file arranged in an orderly fashion according to the titles in the rtf doc. I've attached a sample doc at ee-stuff as its an rtf doc and can't be uploaded here. I have however attached a sample of how the data should be captured in excel - I did this manually to show what data should go where.  SampleConversion.ods

Many thanks

Who is Participating?
Arno KosterConnect With a Mentor Commented:
I see...
I have not used ee stuff before, thanx for showing me !

I have looked into the provided rtf file and regret to have to tell you that parsing this rtf file will simply not be an option.
The file is not structured enough to be able to automatically extract fields and place them correctly.

eg: consider the following texts :


if you want to be able to automatically determine which characters represent a name and which a job title / email address / telephone number, you simply need the rtf file to have a better structure.
Arno KosterCommented:
Writing a VBA subroutine to open a rtf file, process its contents and save it to an excel sheet in itself isn't that difficult. The majority of the work will be in the processing of the rtf contents into the names/addresses etc, this off course depends largely on the rtf structure.

To get you started, you can use these code fragments :

To open an arbitrary file and process its contents line by line (change the debug.print line to process the text).
[If the rtf files are generated from ms word, a lot of garbage is added]
Open "d:\temp\test.rtf" For Input As #1
While Not EOF(1)
    Line Input #1, buffer
    Debug.Print buffer
Close #1

Open in new window

to place text in a worksheet cell
worksheets("Sheet2").cells(7,3)= "Else"

Open in new window

fraser77Author Commented:

Thanks for the suggestions. I'm afraid I'm not that advanced to know how to do this. Can you provide a solution in its completed format? I wouldnt have a clue how to start doing a vb script or where to put it.


Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Arno KosterCommented:
Would you be able to post a zipped sample rtf file, that would get me a starting point for the actual processing.
fraser77Author Commented:
Yes the sample RTF is attached at ee-stuff.com. You just have to paste in the url of this question to find out where it is (sorry if you already know this).

Thanks a lot,

TracyVBA DeveloperCommented:
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.