PDA

View Full Version : Special characters on macros



sclipilici
03-23-2012, 02:07 AM
Hello,
i have a problem with some special characters.
I need to create a macro witch replace some characters with their html code.
The problem is that some characters, like Ğ or Ş are changed when i pasted on macros.
Can you please help me with this problem?

Bob Phillips
03-23-2012, 03:11 AM
Put the characters into cells on a worksheet, and read these into variables and replace using the variables.

sclipilici
03-23-2012, 06:05 AM
Thank you very much, i hoped for a better solution but that is ok too :)

Bob Phillips
03-23-2012, 11:06 AM
Surely, the better solution is the one that works. As you have seen VBA doesn't understand these characters.