Hi Bob and Arvil!
I apologize for the late reply, but this weekend I was absent and I was not at my computer.
Thank you for your for your suggestions that have been a shift in the right direction to solve my problem.
Bob, the answer to your question
Quote:
|
Franci, just to be clear, have you tried running the program since you pasted "è" into the program and saw it recorded as "?"? I ask because it's just possible the VBA Editor doesn't know how to display such characters on the screen but nevertheless stores them correctly. You could try running it and see what happens.
|
I did not mention it, but I tried this before. This replaces all the characters with the "č" sign.
Bob's suggestion
Code:
Cells.Replace What:=&H00E8, Replacement:=&H010D, LookAt:=xlPart, SearchOrder:=xlByRows _ , MatchCase:=True, SearchFormat:=False, ReplaceFormat:=False
didn't work for me, but after I read Arvil post I came up with
Code:
Cells.Replace What:=ChrW(&HE8), Replacement:=ChrW(&H10D), LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=True, SearchFormat:=False, ReplaceFormat:=False
This does the job, so I can continue from here.
Thank you both.