Coding MS Project 2003 VBA for multiple Languages?

I have been coding some macros to run in MS Project 2003 that works fine when run under English language version but when used by a user in say France using the French MUI option fails miserably.

I have a work around for:

ViewApply Name:="Resource Table", singlepane:=True

By seraching for a view with right screen attribute eg

' Get first resource table view
For Each viewObject In myproj.ViewsSingle
If viewObject.Screen = pjResourceSheet Then
ResViewName = viewObject.Name
Debug.Print "ResTab", ResViewName
Exit For
End If
Next viewObject

ViewApply Name:=ResViewName, singlepane:=True

But now have run into the problem of:

projapp.SelectTaskField Row:=1, Column:="Unique ID"

which crashes with Invalid attribute when in French

Does any one have a table that lists all the built in fields for the Resource Table and the Task Uasge table so that I can do something like:

Lang_Name = Application.LanguageSettings.LanguageID( msoLanguageIDUI )

Vlookup( etc)

to get the field name for current language.

I have tried 6 search engines and several Groups but have drawn blank so far.

Seems to be a deficiency in MS Project VBA design to me.




Answer this question

Coding MS Project 2003 VBA for multiple Languages?