Language Differences!!

[Mark]

I program vba app in an English version of Microsoft project. Unfortunately,
becuase of the COM model used some properties seem to be lanaguage dependant.
EG if you look at the task.calendar property the return is a calendar name.
This seems to differ by language which has no use for me as i can't test for
each language. The sam ecan be found on dates where no date is available.
In english you wou;d get N/A but in Dutch for example you would get N.v.t.

Does anyone know of why enum aren't returned instead of Strings? Has anyone
else experience anything similar??

 

[Jan De Messemaeker]

Dag Mark,

Poor you! Having to work with the Dutch version is a punishment of the
Gods - I find the translations to be somewhere between ridiculous and false.

Concretetly, on your 2 questions:
"returns a calendar name" - that is not a language question, any user can
name his base calendars the way he wishes... I use the English version but
my calendars have names in Dutch - so what? Why use a calendar name?

As for testing against "NA" or "Nvt"
Dates shown as NA are represented internally by a high number (I think
2^31 - 1)
So when you test a date to be >2^30 that is equivalent to =NA or =Nvt

You can also test via IsDate(....) which yoields False if it is a string.

Hope this helps.

Vele groeten,