Programme language in ENGLISH <---> Help about Visual Basic in GERMAN
Burkhard Jahnen
I want to get to know the fundamental aspects of Excel Visual Basic. But
that's hard, because the online help assumes that I use English commands.
However, the macro editor needs German commands.
What can I do about this?
Thanks in advance
Burkhard
Mike Snowden
I haven't got German Excel in front of me, but when I last took my sheet to
a German machine, all the worksheet functions had become German. I would
guess that the same is true of intrinsics called from a menu.
There is quite a lot about internationalisation on MSDN & the technical
references, mostly in terms of literals and conversion functions. Well
worth reading.
Mike
--
The above message is purely my own opinion, and has nothing to do
with my employers. Unless explicitly stated, no commitment to anything
is given or implied.
Burkhard Jahnen wrote in article <01bcc2be$698c2be0$LocalHost@Jahnen>...
Hans-Josef Salm
Die Lösung ist ziemlich einfach:
Extras/Optionen auf der Registerkarte Modul/Allgemein Sprache/Land auf
"Englisch/USA" stellen. Das ist ohnehin empfehlenswert, wenn das Makro auch
in einem anderen Sprachbereich laufen soll.
Hope that helps.
hjs
Burkhard Jahnen <Burkhar...@stud.uni-erlangen.de> schrieb im Beitrag
Terje W Isaksen
I had the same problem, but in Swedish.
Excel5-7 used Swedish words in stead of English, even in Visual Basic.
After many unkind words, I did learn to use Swedish for programming.
But, when Excel 97 came, every VisualBasic macro that was opened were
converted into English. Of course, this was not a perfect translation.
I had to go over the code line by line and test.
So, my advice is - use English version for programming, also for
older versions of Excel.
/Terje
Burkhard Jahnen wrote:
>
> I want to get to know the fundamental aspects of Excel Visual Basic. But
> that's hard, because the online help assumes that I use English commands.
> However, the macro editor needs German commands.
>
> What can I do about this?
>
> Thanks in advance
>
> Burkhard
--
Terje W Isaksen SIKROMA AB Sweden
----------------------------------------------------------
email: te...@sikroma.se phone: int+46 470 - 74 55 40
http: www.sikroma.se fax: int+46 470 - 471 35
Jonas Andersson
On 16 Sep 1997 16:35:01 GMT, "Burkhard Jahnen"
<Burkhar...@stud.uni-erlangen.de> wrote:
>I want to get to know the fundamental aspects of Excel Visual Basic. But
>that's hard, because the online help assumes that I use English commands.
>However, the macro editor needs German commands.
>
>What can I do about this?
The easiest way to do this is to write the module in English. In the
menu
Tools | Options
under the sheet Module there is a setting that will allow you to
change the macro language to
English which gives you a match to the documentation.
Jonas
>
>
>Thanks in advance
>
>Burkhard
---------------------------
Jonas Andersson
E-mail: jonas.a...@adiuvabo.se
Håkan Müller
Hi
Problems with language seem to to be annoying a quite few of us outside the
english speaking countries. Functions in formulas translate automatically,
but not macro code.
I have a mixture of swedish and english code (in different modules of course,
as this is required), and would like to be able to translate between the two.
Can anyone tell me if this is at all possible?
The online help, by the way, will show me worksheet function names in
swedish, but macro names (functions, commands etc.) in english. This is
independent on whether I have chosen swedish or english as standard language
for macro modules. I have, however, a vague memory of all online help being
in swedish half a year ago...
How can I find back to swedish if I'd like to?
I'm using Excel 7.0 and Windows NT 3.51
Thanks
Håkan
Burkhard Jahnen wrote:
> I want to get to know the fundamental aspects of Excel Visual Basic. But
> that's hard, because the online help assumes that I use English commands.
> However, the macro editor needs German commands.
>
> What can I do about this?
>
> Thanks in advance
>
> Burkhard