Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Foreign characters aren't processed in a macro
Hi all
I have a macro which replaces non-English characters in a range of cells with english ones. I have been using it for years on a Win NT office 97 set up and now I have changed to Win 2k and office 2k it doesn't work. The reason seems to bethat the VBA macro seems to ignore the accents etc. when it tries to do the find/replace during the macro. If I do the work manually find/replace works. The macro seems to be stripping away the accents when reading the data for the sheet. How can I stop this behaviour. This is urgent please help Thanks in advance Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I get the avg # of inv's processed per project via pivot t | Charts and Charting in Excel | |||
Foreign Characters & Save as... | Excel Discussion (Misc queries) | |||
Display current sheet name being processed in macro | New Users to Excel | |||
Search for foreign characters | Excel Discussion (Misc queries) | |||
Using foreign characters | Excel Discussion (Misc queries) |