Yo, peeps. Am I missing something? How about using the StrConv function?
strExample = StrConv("ÿ",vbUpperCase)
...would assign "Ÿ" to strExample
This function can do a whole slew of conversions, including upper case, lower case, and proper case characters for the entire unicode...