Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Japanese in Macros
I'm sharing an Excel 2007 file with coworkers in Japan. I use the indirect
function to build a formula based on several cells. The problem is, these don't work on Japanese computers, so the formula results in #REF! I was able to record a macro on a Japanese computer to translate from English to Japanese: Cells.Replace What:="[#Totals]", Replacement:="[#WŒv]", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False The WŒv looks like [#集計] on the Japanese computer. When I run the above program, nothing happens. There are no warnings, etc. When I paste from the Japanese macro into the Excel file, it also looks like WŒv. How can I get the Japanese to be properly recognized? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Japanese Yen problem | Excel Discussion (Misc queries) | |||
Japanese Yen | Excel Discussion (Misc queries) | |||
I need Japanese caracter? | Excel Discussion (Misc queries) | |||
Japanese excel97 on Eng Win XP pro sp2 | Setting up and Configuration of Excel | |||
How to display japanese characters? | Excel Programming |