Excel macro source code character encoding issue

Question

My Japanese colleague created an Excel 2010 macro. When I try to edit the macro in excel, the comments have weird characters. It seems like there is a character encoding issue.

Here is some sample code:

Option Explicit

'ƒtƒ@ƒCƒ‹Ši”[ƒpƒXŽw’è iRow,Col j
'DefineXMLƒtƒ@ƒCƒ‹
Public Const P_stTempRow = 5
Public Const P_stTempCol = 3

I checked to see if there was a way to change the encoding used to interpret the source code but couldn't see any settings.

Mark Tolonen · Accepted Answer · 2016-09-12 04:19:22Z

0

It is a character encoding issue. The original file was Japanese-localized using the encoding Shift-JIS, but the file is now being interpreted as the US and Western European default encoding of Windows-1252. I do not know a way to make Excel use another encoding for macros other than the localized default, other than to change your "Current system locale" in Windows settings to Japanese.

answered Sep 12, 2016 at 4:19

Mark Tolonen

181k26 gold badges182 silver badges278 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel macro source code character encoding issue

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related