Well it did work in MapPoint 2006! I did a mistake when inserting the function in Excel VBA.
Glad to see that the code bits you presented in your mini tutorial also works as UDF:s in Excel cells.