VBA icon

Remove and replace special characters in VBA

Insert Symbol

While pulling some XML from the web I ran into some special characters that display on screen, but the MSXML parser refuses to accept. They need to be converted to normal (i.e. unaccented) characters before we can parse the XML.

Continue Reading: Remove and replace special characters in VBA »

VBA icon

Find and replace in text files

binoculars

Replacing text inside text files doesn't mean you need to open them or paste them into Excel. We can do everything strictly in VBA.

Continue Reading: Find and replace in text files »

Excel iconVBA icon

SearchBox Week, Day 5

For the final post of SearchBox Week, I've chosen the following search term:

"vba replace char in filename"

Continue Reading: SearchBox Week, Day 5 »

Site last updated: February 8, 2012