fraser77
asked on
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
Jamie
Many thanks
Jamie
ASKER
HI,
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.
Thanks,
Jamie
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.
Thanks,
Jamie
Sure.
Would you be able to post a zipped sample rtf file, that would get me a starting point for the actual processing.
Would you be able to post a zipped sample rtf file, that would get me a starting point for the actual processing.
ASKER
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,
Jamie
Thanks a lot,
Jamie
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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 in new window
to place text in a worksheet cell
Open in new window