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

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

Answer 1

Hi cj,

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

Regards,
Ashidacchi

Answer 2

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

Answer 3

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

   

Answer 4

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

Answer 5

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