Runtime Error 1004

[jimmylam]

Hi All,

I have some Excel macro enabled spreadsheet and it was working fine on my machine. Due to some other machine got issue with those file, i did some testing on my machine by unregister and register again regsvr32.exe /u c:\...common files\...\vba\vba6\vbe6.dll and c:\windows\syswow64\fm20.dll. After this action, i got same issue on my machine. Reinstall Ms Office 2007 also same issue. Could anyone explain what is going on and how to fix it.
Appreciate on your help.

 

[Roderick_E]

My first suspect is 32bit versus 64bit machines. Check this by going to the START ribbon, right click COMPUTER and select properties. Look for system type. Compare the various machines you are using. Some macros on 64bit machines need a bit different coding.

 

[jimmylam]

hi Roderick,
Thanks for your reply, all systems are 64bit but our Ms Office 2007 is 32bit version.

 

[Roderick_E]

Might take a look at Microsoft's explanation about 32bit vs 64bit -- declarations often don't work on 64bit that previously worked on 32bit -- https://msdn.microsoft.com/en-us/library/office/ee691831(v=office.14).aspx