Hi All
Can anyone advise the following three questions regarding using an
application developed in Excel 2003 English version, when run on a French
version of Excel.

1. The PERSONAL.xls is checked by name on opening, if it is open the
application closes it. Does this have the same or different name in the
French system?

2. I use a few instances of Application.WorksheetFunction.Sum(), will this
still work in the VBA code if run in Excel France or does it need to change?

3. I store and then change, Application Options and ActiveWindow settings,
and refer to these by name e.g.

Application.DisplayFormulaBar = False
ActiveWindow.DisplayVerticalScrollBar = True

Will I have to change the names as they appear differently in the Excel
French user interface, or are the values constant when called from within VBA?

Thanks for any advice

Nigel RS wrote:

Hi All
Can anyone advise the following three questions regarding using an
application developed in Excel 2003 English version, when run on a
French version of Excel.

1. The PERSONAL.xls is checked by name on opening, if it is open the
application closes it. Does this have the same or different name in
the French system?

Is differend with other systems (dutch system: persnlk.xls)


2. I use a few instances of Application.WorksheetFunction.Sum(), will
this still work in the VBA code if run in Excel France or does it
need to change?

Is in all languages the same.

3. I store and then change, Application Options and ActiveWindow
settings, and refer to these by name e.g.

Application.DisplayFormulaBar = False
ActiveWindow.DisplayVerticalScrollBar = True

Will I have to change the names as they appear differently in the
Excel French user interface, or are the values constant when called
from within VBA?

Is in all languages the same.

--

Thanks for the reply, sounds like I only have one change to make regarding
personal.wks - many thanks

"RaceEend" wrote:

Nigel RS wrote:

Hi All
Can anyone advise the following three questions regarding using an
application developed in Excel 2003 English version, when run on a
French version of Excel.

1. The PERSONAL.xls is checked by name on opening, if it is open the
application closes it. Does this have the same or different name in
the French system?

Is differend with other systems (dutch system: persnlk.xls)


2. I use a few instances of Application.WorksheetFunction.Sum(), will
this still work in the VBA code if run in Excel France or does it
need to change?

Is in all languages the same.

3. I store and then change, Application Options and ActiveWindow
settings, and refer to these by name e.g.

Application.DisplayFormulaBar = False
ActiveWindow.DisplayVerticalScrollBar = True

Will I have to change the names as they appear differently in the
Excel French user interface, or are the values constant when called
from within VBA?

Is in all languages the same.

--

As I understand it, there is nothing inherently special about
"Personal.xls", or whatever it's name in any language.
It is merely a WB installed by default in the XLSTART folder. You can delete
or rename yours to anything.
You can check for WBs that open upon Excel start up in :
Application.StartupPath
Application.AltStartupPath

Depends what the aim is.

NickHK

"Nigel RS" ...
Thanks for the reply, sounds like I only have one change to make regarding
personal.wks - many thanks

"RaceEend" wrote:

Nigel RS wrote:

Hi All
Can anyone advise the following three questions regarding using an
application developed in Excel 2003 English version, when run on a
French version of Excel.

1. The PERSONAL.xls is checked by name on opening, if it is open the
application closes it. Does this have the same or different name in
the French system?

Is differend with other systems (dutch system: persnlk.xls)


2. I use a few instances of Application.WorksheetFunction.Sum(), will
this still work in the VBA code if run in Excel France or does it
need to change?

Is in all languages the same.

3. I store and then change, Application Options and ActiveWindow
settings, and refer to these by name e.g.

Application.DisplayFormulaBar = False
ActiveWindow.DisplayVerticalScrollBar = True

Will I have to change the names as they appear differently in the
Excel French user interface, or are the values constant when called
from within VBA?

Is in all languages the same.

--

Thanks for the tip - you're right it coud be called anything. Using the
startup folders will be more fooolproof

Cheers


"NickHK" wrote:

As I understand it, there is nothing inherently special about
"Personal.xls", or whatever it's name in any language.
It is merely a WB installed by default in the XLSTART folder. You can delete
or rename yours to anything.
You can check for WBs that open upon Excel start up in :
Application.StartupPath
Application.AltStartupPath

Depends what the aim is.

NickHK

"Nigel RS" ...
Thanks for the reply, sounds like I only have one change to make regarding
personal.wks - many thanks

"RaceEend" wrote:

Nigel RS wrote:

Hi All
Can anyone advise the following three questions regarding using an
application developed in Excel 2003 English version, when run on a
French version of Excel.

1. The PERSONAL.xls is checked by name on opening, if it is open the
application closes it. Does this have the same or different name in
the French system?

Is differend with other systems (dutch system: persnlk.xls)


2. I use a few instances of Application.WorksheetFunction.Sum(), will
this still work in the VBA code if run in Excel France or does it
need to change?

Is in all languages the same.

3. I store and then change, Application Options and ActiveWindow
settings, and refer to these by name e.g.

Application.DisplayFormulaBar = False
ActiveWindow.DisplayVerticalScrollBar = True

Will I have to change the names as they appear differently in the
Excel French user interface, or are the values constant when called
from within VBA?

Is in all languages the same.

--