I have some VBA code that works in Excel 2003. It references the calendar in mscal.ocx. Typically, when I've moved it to a new machine (XP, 32-bit), I've had to copy mscal.ocx there and run regsvr32 mscal.ocx and then everything works.
But on a new, 64-bit windows 7 machine, with Excel 2003 on it, regsvr32 doesn't work for mscal.ocx. I get this error message:
"The module 'mscal.ocx' may not be compatible with the version of Windows that you're running. Check if the module is compatible with an x86 (32-bit) or x64 (64-bit) version of regsvr32.exe"
Is there any easy fix to this?
Software/Hardware used: 64-bit windows 7 excel 2003 and mscal.ocx