Excel in French

Hello,
I have a problem with a macro which has been created on Excel in English.
When it runs on an English station it's ok. When I launch it on a pc with
Excel in French There is an error. Have you any idea about this ? When I
just change the language parameters from french to english, the macro is
going fine.
thanks for any idea
Ray

Ray,

Normally, macros run fine being taken across, but there are some things that
you have to watch out for. Dates tend to one area of concern, but to really
help you we would need to know what code is erroring out.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ray" <rgomange@csc.com> wrote in message
news:OT2TN1nnGHA.4864@TK2MSFTNGP04.phx.gbl...
> Hello,
> I have a problem with a macro which has been created on Excel in English.
> When it runs on an English station it's ok. When I launch it on a pc with
> Excel in French There is an error. Have you any idea about this ? When I
> just change the language parameters from french to english, the macro is
> going fine.
> thanks for any idea
> Ray
>
>

Thanks for your answer,
I checked my code and there's no date in the code in it.
You could see the code here in my file at this adress :
http://cjoint.com/?hdkH52RcVi.
the sheet is duty selection, and then click on Create conflicts Reports
button.
It should work if you do, because your excel is in English.
If I do, I receive this msg : "At least one duty box has to be checked.",
even I have checked boxes.
Thanks for your help
ray



"Bob Phillips" <bob.NGs@somewhere.com> a écrit dans le message de news:
eX2n3NonGHA.3340@TK2MSFTNGP02.phx.gbl...
> Ray,
>
> Normally, macros run fine being taken across, but there are some things
> that
> you have to watch out for. Dates tend to one area of concern, but to
> really
> help you we would need to know what code is erroring out.
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "Ray" <rgomange@csc.com> wrote in message
> news:OT2TN1nnGHA.4864@TK2MSFTNGP04.phx.gbl...
>> Hello,
>> I have a problem with a macro which has been created on Excel in English.
>> When it runs on an English station it's ok. When I launch it on a pc with
>> Excel in French There is an error. Have you any idea about this ? When I
>> just change the language parameters from french to english, the macro is
>> going fine.
>> thanks for any idea
>> Ray
>>
>>
>
>

Have you stepped through it and identified the line it errors on?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ray" <rgomange@csc.com> wrote in message
news:OlX4NoqnGHA.4572@TK2MSFTNGP05.phx.gbl...
> Thanks for your answer,
> I checked my code and there's no date in the code in it.
> You could see the code here in my file at this adress :
> http://cjoint.com/?hdkH52RcVi.
> the sheet is duty selection, and then click on Create conflicts Reports
> button.
> It should work if you do, because your excel is in English.
> If I do, I receive this msg : "At least one duty box has to be checked.",
> even I have checked boxes.
> Thanks for your help
> ray
>
>
>
> "Bob Phillips" <bob.NGs@somewhere.com> a écrit dans le message de news:
> eX2n3NonGHA.3340@TK2MSFTNGP02.phx.gbl...
> > Ray,
> >
> > Normally, macros run fine being taken across, but there are some things
> > that
> > you have to watch out for. Dates tend to one area of concern, but to
> > really
> > help you we would need to know what code is erroring out.
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (replace somewhere in email address with gmail if mailing direct)
> >
> > "Ray" <rgomange@csc.com> wrote in message
> > news:OT2TN1nnGHA.4864@TK2MSFTNGP04.phx.gbl...
> >> Hello,
> >> I have a problem with a macro which has been created on Excel in
English.
> >> When it runs on an English station it's ok. When I launch it on a pc
with
> >> Excel in French There is an error. Have you any idea about this ? When
I
> >> just change the language parameters from french to english, the macro
is
> >> going fine.
> >> thanks for any idea
> >> Ray
> >>
> >>
> >
> >
>
>

I noticed your checkboxes on sheet 'Duty Selection' have linkedCell such as
'Listing of Duties'!E2.
That sheet does not exist!

HTH
--
AP

"Ray" <rgomange@csc.com> a écrit dans le message de news:
OlX4NoqnGHA.4572@TK2MSFTNGP05.phx.gbl...
> Thanks for your answer,
> I checked my code and there's no date in the code in it.
> You could see the code here in my file at this adress :
> http://cjoint.com/?hdkH52RcVi.
> the sheet is duty selection, and then click on Create conflicts Reports
> button.
> It should work if you do, because your excel is in English.
> If I do, I receive this msg : "At least one duty box has to be checked.",
> even I have checked boxes.
> Thanks for your help
> ray
>
>
>
> "Bob Phillips" <bob.NGs@somewhere.com> a écrit dans le message de news:
> eX2n3NonGHA.3340@TK2MSFTNGP02.phx.gbl...
>> Ray,
>>
>> Normally, macros run fine being taken across, but there are some things
>> that
>> you have to watch out for. Dates tend to one area of concern, but to
>> really
>> help you we would need to know what code is erroring out.
>>
>> --
>> HTH
>>
>> Bob Phillips
>>
>> (replace somewhere in email address with gmail if mailing direct)
>>
>> "Ray" <rgomange@csc.com> wrote in message
>> news:OT2TN1nnGHA.4864@TK2MSFTNGP04.phx.gbl...
>>> Hello,
>>> I have a problem with a macro which has been created on Excel in
>>> English.
>>> When it runs on an English station it's ok. When I launch it on a pc
>>> with
>>> Excel in French There is an error. Have you any idea about this ? When I
>>> just change the language parameters from french to english, the macro is
>>> going fine.
>>> thanks for any idea
>>> Ray
>>>
>>>
>>
>>
>
>