Sort-Problem by English and German Version

M

Michael

Hello!

I have a problem, when I sort the resources with VBA with an english and
german Version from MS-Project 2007.

sort Key1:="Type", Key2:="Name"

The "Type" in English is Work/Material/Cost. When I sort by "Type", then
first the "Cost"-Resource then "Material"-Resource and then "Work"-Resource.

In German is "Work"="Arbeit", "Material"="Material" and "Cost"="Kosten".
The result is exact inverse.

I know, that Project work internal with:
0 ... Work
1 ... Matreial
2 ... Cost

Why can I sort the resource by the internal number of "Type". Then I was
independent from the language-version.

Thank's
Michael
 
Top