I have a VBA project that takes data in a table in a Word document and transfers the data to an Excel sheet. This table often contains Chinese characters.

The problem I have is that working on a PC in the US and in Europe, the transfer of the Chinese characters from the Word table to Excel works perfectly. However working on a PC in China, the Chinese characters do not transfer over at all. It's not a case of having "???" or random squares in place of the Chinese characters. The fields with Chinese text are left completely blank. It makes no sense that Chinese characters in China do not transfer properly. To add more confusion, Korean characters from the same PC in China do transfer from Word to Excel.

So, is this a VBA problem, a Word problem, or Excel problem? Or is this a system locale/font encoding problem?

Any suggestions?