This is causing me some problems.

I have written an automated report in Excel 97 (English)
which has been tested extensively (tested on Excel 2000 as
well).

However when my colleagues in France run the report they
get an error 9 (in French). A colleague who speaks French,
trapped the error and printed me a copy of where it
occurred in my program.

I then changed the program and re-tested it, and it ran
ok. However it is still giving this error 9 in the French
version of Excel.

Can anyone suggest how I can resolve this problem ?

Does excel in French run differently to English ?

This is the first time I have encountered such a problem,
and I think it is down to the way I am saving the finished
report to the C drive on their machines.

Any insight/suggestions would be gratefully received.

It would help in solving this to know the text of the error message in
English and the line of code that is breaking.

--
Jim Rech
Excel MVP
"Alan Hutchins" wrote in message
...
| This is causing me some problems.
|
| I have written an automated report in Excel 97 (English)
| which has been tested extensively (tested on Excel 2000 as
| well).
|
| However when my colleagues in France run the report they
| get an error 9 (in French). A colleague who speaks French,
| trapped the error and printed me a copy of where it
| occurred in my program.
|
| I then changed the program and re-tested it, and it ran
| ok. However it is still giving this error 9 in the French
| version of Excel.
|
| Can anyone suggest how I can resolve this problem ?
|
| Does excel in French run differently to English ?
|
| This is the first time I have encountered such a problem,
| and I think it is down to the way I am saving the finished
| report to the C drive on their machines.
|
| Any insight/suggestions would be gratefully received.

Found this at:
www.synkronizer.com

Page dump (edited):

Problems with French Excel versions

If you are working with a French version of Microsoft Excel the
following error may occur:

This workbook has been password protected with an encryption scheme not
available in this region. This workbook cannot be opened.

This is an known error by Microsoft and is described in the following
articles:

http://support.microsoft.com/default...;EN-US;q278679

http://support.microsoft.com/default...B;EN-US;213833

If you are working with Excel 97, you can solve the problem by taking
the following steps:

- change the country settings from French to English
- reset the country settings



hth.. <g


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Alan Hutchins" wrote:

This is causing me some problems.

I have written an automated report in Excel 97 (English)
which has been tested extensively (tested on Excel 2000 as
well).

However when my colleagues in France run the report they
get an error 9 (in French). A colleague who speaks French,
trapped the error and printed me a copy of where it
occurred in my program.

I then changed the program and re-tested it, and it ran
ok. However it is still giving this error 9 in the French
version of Excel.

Can anyone suggest how I can resolve this problem ?

Does excel in French run differently to English ?

This is the first time I have encountered such a problem,
and I think it is down to the way I am saving the finished
report to the C drive on their machines.

Any insight/suggestions would be gratefully received.