Hello Garry,

You have a special problem here.
Until Excel 5 VBA was still in the local language.
So if VBA code was made in a non-English file, other languages
couldn't use that file, without saving a special file in one of the
directories. I can't remember which one, but one could download it
from the MS site. (can maybe still be found).

But even when having this file installed, translation wasn't always
good. I do remember very well (regularly caused trouble).

That why since XL 97, VBA became common Native English.
There is nothing else to do for you than checking which VBA lines
aren't translated and correct them manually.
This problem only excists for files with foreign language VBA made in
XL5 and XL95 (last one I assume)?
Later editions doesn't have this problem anymore.

So I think you should manually correct the problem, mostly it are only
a few which translate wrong.

Best regards
Eric


Garry Jones wrote in message ...
Niek Otten wrote:

Hi Garry,

Your formulas will be translated automatically

Thanks for your answer.

In the meantime I have now seen my work in action in an English version
of Excel. Like you said the IF and etc were okay.

But, I was unable to click on a couple of buttons that should execute
code and bring up users forms.

This was one offending line...

=INBÄDDAT("Forms.CommandButton.1";"")

Nothing happened when I clicked on the button

However, this was not Excel 97 PC Swedish, it was Excel 5 English for an
English MAC. Could that be the reason my buttons did not work or is this
likely to be because of the language problem. I created the file on a
windows 98 pc, excel 97.

I did not have access to this mac for very long today for any further
investigation, I hope to take a futher look later in the week.

Refer to Eric Desart's site to find a translation guide.

I have checked around http://www.acoustics-noise.com/ - is that the
right site?, I can't find a translation guide there.

I know it's asking a lot, but I would be very grateful if you could
download my file and see if the buttons work in English Excel.

In that case it is at

http://www.algonet.se/~morack/league2.xls

It will ask for macros, you do not need to turn macros on for this to
work.

When I know it's working I am going to send this file to England to be
used on a pc.

Garry Jones
Sweden