Thanks for the help... It turns out the problem was I'm in fact dealing with a Unicode file. My parter sent it over to me and told me that it's an ASCII file FOR SURE, and NOT Unicode. That's what I get for listening to him.
VBA was converting all the normal characters to standard ASCII...
Fr33dan,
That's what I do. Every single character is fine, except for the special ones.
I've tried changing to the notepad font that is being used:
Application.StandardFont = "Lucida Console"
No go.
Now I'm trying encoding and charactersets...
It opens fine and displays the "TM" and the bullet inside of notepad.
How do I change the font for the entire sheet?
I tried ActiveSheet.Font.Name = "Tahoma", but it errors out on me.
Forgive me for being a noob at this, but I'm a C++ programmer trying to write an excel app for the...
I'm using the default font in Excel, and watching the variables as I load them in, in the IDE. I then load them in cells and it confirms my suspicions.
Do you think that the current font does not support the characters and is having difficulty loading them in?
Chris
I'm at wit's end, guys. I can't find anything in these forums or on Google that can help me.
I'm simply trying to read in a simple notepad ASCII text file that has the TradeMark Symbol and the bullet symbol. No matter what I do, they're always read in as a combination of <quotation>X where...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.