-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
RTF to EXCEL
- Thread starter user9000
- Start date
Maybe you could save the RTF file as an HTML document in Word and then load that into Excel. Assuming it's got tables, Word will generate HTML tables for it which Excel can then handle.
Meanwhile, send me a dummy version of the file that just a few lines long and I'll work on a programming solution.
Meanwhile, send me a dummy version of the file that just a few lines long and I'll work on a programming solution.
Upvote
0
Excel Facts
How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Wow, what an interesting document. Each "table cell" is actually a text box positioned on the page based on what appears to be it's twips location (there are 1440 twips per inch). This makes cutting and pasting extremely difficult if not impossible. I tried converting it into a table with no success. I also tried exporting it to a text file and though it's in order, it loses it's linear layout.
Someone at Crystal was very clever as this method of transmitting a database makes it extremely difficult to mine for information.
I'll continue working on the problem after my lunch is over...
Someone at Crystal was very clever as this method of transmitting a database makes it extremely difficult to mine for information.
I'll continue working on the problem after my lunch is over...
Upvote
0
Mark-
Yes exactly. That's the problem. They know it's hard to mine for data and with such a large sum of money involved, you can understand their reticence to provide anything but the most difficult format to me hack on. Thanks for your help.
Brian
Yes exactly. That's the problem. They know it's hard to mine for data and with such a large sum of money involved, you can understand their reticence to provide anything but the most difficult format to me hack on. Thanks for your help.
Brian
Upvote
0
Mark-
Yes exactly. That's the problem. They know it's hard to mine for data and with such a large sum of money involved, you can understand their reticence to provide anything but the most difficult format to me hack on. Thanks for your help.
Brian
Yes exactly. That's the problem. They know it's hard to mine for data and with such a large sum of money involved, you can understand their reticence to provide anything but the most difficult format to me hack on. Thanks for your help.
Brian
Upvote
0
XL-Dennis
Well-known Member
- Joined
- Jul 27, 2002
- Messages
- 1,920
Mark,
Seagate has a RTF-fileformat that is based on Crystal Reports Encapsulated Page Format (EPF).
The developer of the report has propably used this fileformat which create this kind of problem...
user9000,
Instead ot trying to solve "Ghorton´s knote" can You go back to the source and ask for a workable fileformat?
Kind regards,
Dennis
Seagate has a RTF-fileformat that is based on Crystal Reports Encapsulated Page Format (EPF).
The developer of the report has propably used this fileformat which create this kind of problem...
user9000,
Instead ot trying to solve "Ghorton´s knote" can You go back to the source and ask for a workable fileformat?
Kind regards,
Dennis
Upvote
0
<Instead ot trying to solve "Ghorton´s knote" can You go back to the source and ask for a workable fileformat?>
Dennis, they refuse to send a workable format because they know I will then be able to utilize the data and manipulate it.
Brian
Dennis, they refuse to send a workable format because they know I will then be able to utilize the data and manipulate it.
Brian
Upvote
0
Similar threads
- Question
