How to convert BIG5 code (&#xxxxx;) to Chinese symbol

[kenneth540]

Hi All,

I'm writing a VBA app that reads data from a web page (.html file). The input file contains some BIG5 code in it (&#xxxxx; where xxxxx is a 5-digit code). I need to be able to convert the BIG5 code back to the corresponding Chinese symbol before writing it to an Access database table. Does anyone know how to do this in VBA?

TIA,
Kenneth