View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RaceEend RaceEend is offline
external usenet poster
 
Posts: 7
Default International Issues

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.

--