I'm having the same issue with spreadsheets developed in English version
EXCEL2003, being used in Germany. Anyone know why the Analysis Tool Pak
functions aren't translated automatically like all the "standard"
functions?

Can anyone suggest a good fix - I don't want to maintain multiple
versions of the same spreadsheet?

My own thoughts are to create a new UDF... xNETWORKDAYS() and within
that, use the VBA function equivalent. However, since it would come
from the add-in file atpvb*EN*.xls (where *EN* refers to English), will
I just end up with the same "not translated" issue? Will my German
colleagues have an atpvba*DE*.xls to install the toolpack and again if I
call the funciton in "english" it will fail?

Apprectiate any help.



;343946 Wrote:
I have a spreadsheet that I have several references to the formula
'Networkdays'. The spreadsheet works great using the English version
of Excel however, I have collegues that use a French copy of Excel and
the spreadsheet does not function using that version of Excel.

In order to get the spreadsheet to work, I have to change all the
references in the spreadsheet from 'Networkdays' to 'NB.JOURS.OUVRES'
and then it will work.

Is there anyway I can set up the spreadsheet so that it will work in
both languages without having to re-write the formual for different
versions of Excel? Maybe a statement 'if Excel ver=French, use
NB.JOURS.OUVRES, if English use Networkdays'?
thx

Mel


--
MichaelH
------------------------------------------------------------------------
MichaelH's Profile: http://www.thecodecage.com/forumz/member.php?userid=589
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=96230