Difficulties with replacing certain language-specific characters using VBA.

Franci · #1 05-28-2018, 01:20 AM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
A Macro to break lines automatically after specific number of characters	Annie Wordy	Word VBA	1	11-03-2017 08:36 PM
Deleting Characters in a specific location in Word 2010	ppayaw	Word VBA	8	12-13-2016 08:11 AM
Customize grammar settings for specific language?	jpgauvin	Word	0	12-05-2016 03:06 PM
How do I Remove A Specific Amount of Characters from Lines in a Document?	tatihulot	Word	5	01-22-2016 05:55 AM
Extract Line of Text w/ specific characters up to the paragraph character, send to Excel	dmarie123	Word VBA	10	07-20-2015 12:16 AM