Mac Excel - VBA written in Japanese gets corrupted












0















I have an excel file with a password-protected VBA macro written with Japanese characters that I'm having quite the trouble of working with.



Whenever I tried opening it on Excel 2016 for Mac OS X, the file gives me several error pop ups and when I go to view the macro, the password protection is gone and when can view the VBA code, it is filled with mojibake text for all the Japanese characters.



I've run this same file with a Windows PC before and it works smoothly, so I'm thinking this is a Mac Office-specific issue.



Is there anyway to fix this on Mac Excel?










share|improve this question























  • What's the language of Module in Workbook? Did Mac use the same language as Windows?

    – Lee
    Dec 19 '18 at 9:07











  • As far as I know, the workbook was written with a Japanese Windows PC, and my Mac was setup in US English.

    – Noir Antares
    Dec 20 '18 at 0:16











  • Go to VB editor and change the Module name to English, the Module name in English language Mac maybe mess up.

    – Lee
    Dec 20 '18 at 1:34
















0















I have an excel file with a password-protected VBA macro written with Japanese characters that I'm having quite the trouble of working with.



Whenever I tried opening it on Excel 2016 for Mac OS X, the file gives me several error pop ups and when I go to view the macro, the password protection is gone and when can view the VBA code, it is filled with mojibake text for all the Japanese characters.



I've run this same file with a Windows PC before and it works smoothly, so I'm thinking this is a Mac Office-specific issue.



Is there anyway to fix this on Mac Excel?










share|improve this question























  • What's the language of Module in Workbook? Did Mac use the same language as Windows?

    – Lee
    Dec 19 '18 at 9:07











  • As far as I know, the workbook was written with a Japanese Windows PC, and my Mac was setup in US English.

    – Noir Antares
    Dec 20 '18 at 0:16











  • Go to VB editor and change the Module name to English, the Module name in English language Mac maybe mess up.

    – Lee
    Dec 20 '18 at 1:34














0












0








0








I have an excel file with a password-protected VBA macro written with Japanese characters that I'm having quite the trouble of working with.



Whenever I tried opening it on Excel 2016 for Mac OS X, the file gives me several error pop ups and when I go to view the macro, the password protection is gone and when can view the VBA code, it is filled with mojibake text for all the Japanese characters.



I've run this same file with a Windows PC before and it works smoothly, so I'm thinking this is a Mac Office-specific issue.



Is there anyway to fix this on Mac Excel?










share|improve this question














I have an excel file with a password-protected VBA macro written with Japanese characters that I'm having quite the trouble of working with.



Whenever I tried opening it on Excel 2016 for Mac OS X, the file gives me several error pop ups and when I go to view the macro, the password protection is gone and when can view the VBA code, it is filled with mojibake text for all the Japanese characters.



I've run this same file with a Windows PC before and it works smoothly, so I'm thinking this is a Mac Office-specific issue.



Is there anyway to fix this on Mac Excel?







microsoft-excel vba microsoft-office-2016






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Dec 18 '18 at 0:51









Noir AntaresNoir Antares

101




101













  • What's the language of Module in Workbook? Did Mac use the same language as Windows?

    – Lee
    Dec 19 '18 at 9:07











  • As far as I know, the workbook was written with a Japanese Windows PC, and my Mac was setup in US English.

    – Noir Antares
    Dec 20 '18 at 0:16











  • Go to VB editor and change the Module name to English, the Module name in English language Mac maybe mess up.

    – Lee
    Dec 20 '18 at 1:34



















  • What's the language of Module in Workbook? Did Mac use the same language as Windows?

    – Lee
    Dec 19 '18 at 9:07











  • As far as I know, the workbook was written with a Japanese Windows PC, and my Mac was setup in US English.

    – Noir Antares
    Dec 20 '18 at 0:16











  • Go to VB editor and change the Module name to English, the Module name in English language Mac maybe mess up.

    – Lee
    Dec 20 '18 at 1:34

















What's the language of Module in Workbook? Did Mac use the same language as Windows?

– Lee
Dec 19 '18 at 9:07





What's the language of Module in Workbook? Did Mac use the same language as Windows?

– Lee
Dec 19 '18 at 9:07













As far as I know, the workbook was written with a Japanese Windows PC, and my Mac was setup in US English.

– Noir Antares
Dec 20 '18 at 0:16





As far as I know, the workbook was written with a Japanese Windows PC, and my Mac was setup in US English.

– Noir Antares
Dec 20 '18 at 0:16













Go to VB editor and change the Module name to English, the Module name in English language Mac maybe mess up.

– Lee
Dec 20 '18 at 1:34





Go to VB editor and change the Module name to English, the Module name in English language Mac maybe mess up.

– Lee
Dec 20 '18 at 1:34










0






active

oldest

votes











Your Answer








StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1385397%2fmac-excel-vba-written-in-japanese-gets-corrupted%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes
















draft saved

draft discarded




















































Thanks for contributing an answer to Super User!


  • Please be sure to answer the question. Provide details and share your research!

But avoid



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1385397%2fmac-excel-vba-written-in-japanese-gets-corrupted%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

Plaza Victoria

Puebla de Zaragoza

Musa