Macros and China
 

Hi, I have created some macros using Excel 2003. They work well, that is they
do everything that they were designed to do... copying data from one workbook
to another and arranging data. The problem is that the person I created them
for wants to use them on a PC in China.

The code is located in a .xla file and normally when this file is loaded a
menu is added. However for this PC, it does attempt to run but goes straight
to the error handler. Unfortunitely with my knowledge of manderin I did not
understand the error message.

As their version of Office is in Manderin, does this mean that the code is
also translated? If the code is translated does the translator mess with the
code in the same way as a movie subtitles?

They are attempting to run this in Excel 2000.

So I don't know whether this is likely to be a problem with running code
created in 2003 on a 2000 PC, a translation thing or something completely
different.

Any ideas appreciated :-)

--
Many thanks
Jonathan Parminter

Macros and China
 

Jonathan,
You should first test your code on the English version of their Excel, as
you always develop on the lowest version that you intend to support..
That will probably solve (most of) your problems.

NickHK

"Jonathan" wrote in message
...
Hi, I have created some macros using Excel 2003. They work well, that is
they
do everything that they were designed to do... copying data from one
workbook
to another and arranging data. The problem is that the person I created
them
for wants to use them on a PC in China.

The code is located in a .xla file and normally when this file is loaded a
menu is added. However for this PC, it does attempt to run but goes
straight
to the error handler. Unfortunitely with my knowledge of manderin I did
not
understand the error message.

As their version of Office is in Manderin, does this mean that the code is
also translated? If the code is translated does the translator mess with
the
code in the same way as a movie subtitles?

They are attempting to run this in Excel 2000.

So I don't know whether this is likely to be a problem with running code
created in 2003 on a 2000 PC, a translation thing or something completely
different.

Any ideas appreciated :-)

--
Many thanks
Jonathan Parminter

Macros and China
 

The problem is most likely to do with running the code on 2000 and no i
doesn't translate the code only the messages.
When you using code with a foreign language version always display bot
an error message and an error number. The error number always means th
same thing and you can then look it up in english.

hope this help

--
tony
-----------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...fo&userid=2107
View this thread: http://www.excelforum.com/showthread.php?threadid=55590

Macros and China
 

Thanks guys, you're correct. I found a 2000 version and that a couple of
method arguments are new to 2003... specifically in the range.find and
range.sort

--
Many thanks
Jonathan Parminter


"tony h" wrote:


The problem is most likely to do with running the code on 2000 and no it
doesn't translate the code only the messages.
When you using code with a foreign language version always display both
an error message and an error number. The error number always means the
same thing and you can then look it up in english.

hope this helps


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=555901