Sort problem with an english and german Version

[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

 

[Gérard Ducouret]

Michael,

You could use a custom field (Number1 for ex) with a simple formula : [Type]
Rename it as "Sort on Type" for ex. Then sort the resources on that field.
Hope this helps,

Gérard Ducouret

 

[Michael Freitter]

Hello Gérard,

thank you, it's work fine.

Michael

Michael,

You could use a custom field (Number1 for ex) with a simple formula : [Type]
Rename it as "Sort on Type" for ex. Then sort the resources on that field.
Hope this helps,

Gérard Ducouret

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