locked
Is this a known bug: fail to open xlsm with some non-English charaters named VBA module on a 64-bit OS? RRS feed

  • Question

  • I've met such a problem:

    I've installed Office 2007 and Office 365 on my Win7-64bit system. I cannot open some xlsm file with Excel365 which was developed in Excel 2007. It said something like VBA damaged. And the file was working well and I didn't make any change to it. Finally someone told me that there's probably some non-English characters in the module's name.

    To find out what happened to this file, I did some tests:

    1. The file can be opened with excel 2007 on win7 32-bit system. And then I confirm there's a moduled named in Chinese.

    2. The file cannot be opened with excel 2007 on win7  64-bit system.

    (After the module's name has been changed, it's OK.)

    3. The file cannot be opened with excel 365 on win7 64-bit system.

    (After the module's name has been changed, it's OK.)


    cj

    Monday, December 26, 2016 2:55 AM

All replies

  • Hi cj,

    Could you share the problematic file via cloud storage such as OneDrive, DropBox, etc?

    Regards,
    Ashidacchi

    Monday, December 26, 2016 3:46 AM
  • Hi Ashidacchi,

    Thanks for your reply.

    I try to upload such kind of VBA file to OneDrive. Please help to check. Thank you!

    https://1drv.ms/x/s!AisG_XDwhilwjDAzsPN9rFL6ZHks


    cj

    Monday, December 26, 2016 5:53 AM
  • Hi cj,

    Thank you for sharing a file.
    I downloaded and could open it without problem.
    (I could not reproduce your issue) 
       1. Windows 10 Pro (64-bit), Excel 2016 (32-bit) -- both Japanese version
       2. Windows 7 Ultimate (64-bit), Excel 2007 (32-bit) -- both Japanese version

       Below is with 2.

    Regards,
    Ashidacchi

       
    Monday, December 26, 2016 6:13 AM
  • Thank you for the reply and test.

    I made another test.

    1. Excel file (with nonEnglish module) created by Excel 365 (Chinese version) on Win7 64-bit English version

    https://1drv.ms/x/s!AisG_XDwhilwjDHiXXjCXHQmS7TY

    (I created this file with excel365 , saved and closed it . And then cannot open it.

    2. Excel file (without non-English name module) created by Excel 365(Chinese version) on Win7 64-bit English version with

    https://1drv.ms/x/s!AisG_XDwhilwjDIjGsNK6W8mf41G

    I can open this file.


    cj

    Monday, December 26, 2016 8:11 AM
  • Hi cj,

    Below is my result:

    1. test-1-CreatedbyWin7-64_Excel365-with-nonEng.xlsm

      a) Could Not open with Win7 64-bit (Japanese), Excel 2007 32-bit (Japanese)
      b) Could open with Win7 64-bit (Japanese), Excel 2016 32-bit (Japanese)
      c) Could open with Win10 64-bit (Japanese), Excel 2016 32-bit (Japanese)
      
    2. test-2-CreatedbyWin7-64-Excel365-without-NonEng.xlsm

      a) Could open with Win7 64-bit (Japanese), Excel 2007 32-bit (Japanese)
      b) Could open with Win7 64-bit (Japanese), Excel 2016 32-bit (Japanese)
      c) Could open with Win10 64-bit (Japanese), Excel 2016 32-bit (Japanese)

    I've created a sample by Excel 2007 in Win7, that has a standard module with Japanese module-name.
    It can be opened with both Excel 2007 and 2016.

    Your test-1 shows different in module name, and cannot be changed by the module-name.
    I'm afraid the module is corrupted.


    My test shows the same in module name, and can be changed by the module-name.


    Please try to create a new module with Chinese charactes, and copy code of the original modele to the new module. 

    Regards,
    Ashidacchi

    • Edited by Ashidacchi Monday, December 26, 2016 9:21 AM
    Monday, December 26, 2016 9:19 AM