Chinese Characters and VBA

SpinachConvention

Guest

Posts: n/a

27th Feb 2008

I've written a piece of Excel VBA code which includes searching for °C
(degrees centigrade) in some of the code. I'm now trying to get this
code to work on a colleagues computer who is from China. His version
of Excel changes the °C into a Chinese character in VBA. This causes
the macro to fall over.

Does anyone have any ideas how to force VBA to use English characters
by default?

Thanks for any and all assistance!

« enabling & disabling attached toolbar stops sheet selection | Range error »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Chinese Characters not displaying in Chinese Program	=?Utf-8?B?QW5kcmV3?=	Windows Vista General Discussion	4	14th Jan 2009 03:33 PM
Chinese application is not showing Chinese characters	=?Utf-8?B?QnJva2VuQm9ra2VuUHJvZHVjdGlvbnM=?=	Windows Vista General Discussion	3	28th Jul 2007 12:33 AM
Chinese Characters	=?Utf-8?B?QkE=?=	Microsoft Access Database Table Design	0	26th Oct 2005 04:59 AM
Translation of Tradition Chinese Characters to Simplified Chinese Characters		Microsoft Access	0	9th Jun 2004 09:45 AM
Chinese characters	Hart	Windows XP Internet Explorer	1	25th May 2004 11:31 PM