VBA parsing Word document into Excel with problems [resolved]

[ethyachk]

Thanks for the reply!

I am very aware that the parsing must be done before it hits Excel unfortunately. I'm quite knowledgeable about what I can't do at this point. I just tried your convert to RTF suggestion, which I'm kicking myself for not thinking of on my own. On the up side it gets rid of one set of those unrecognized characters! On the down side it also creates a pile of brand new ones. I'm not giving up on your idea yet but the work day is coming to a close. If I do not get the opportunity to try this out thoroughly enough before quittin' time, I will post on Monday with further results.


-S

[RobDog888]

Ok, glad to have helped give you another way to look at it. Also, try different formats too to see which one
gets you the closest so you will do the least amount of fixing up.

[ethyachk]

Well, I've tried RTF, Text, DOS Text, Encoded Text, and HTML. So far, no luck. Each one looks promising until I find something psychotic that the encoding did and turned something (or somethings) into a square. HTML was the closest, but it still was not free of encoding errors. I will have to put this off until Monday, but I will fight with it more then if I have the time.

In case you were wondering, "it can't be done" is a perfectly acceptable answer. If it can't be done we should have the authority to insist on standard fonts.

-S

[RobDog888]

Since the document was created on another system with that special font installed on it. Any other system
may or may not be able to display it correctly. I would insist that you get a requirement for a standard font.
If they change the font again or ??? they are going to say "why doesn't it work now?" and look back to you guys.

HTH

[ethyachk]

I am going to have to agree with you on that one. After all this work, I'm fairly certain that there's no reasonable way to do what would be required for this situation. The problem is someone else breaking standards more than code, so it's time to unleash the power that is my manager!

That's more or less what I was expecting the final answer to be, but you've still managed to give me more understanding of VB! I'll be reading and posting here more. Thanks for all your help!

-S