Hi there,
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?
Thanks!
-Dave
Software/Hardware used:
64-bit windows 7 excel 2003 and mscal.ocx
ASKED:
January 15, 2010 3:16 PM
UPDATED:
April 19, 2013 12:26 PM
I was getting the exact same errors when I installed a macro for a client yesterday running Office 2007 on Windows 7. It turns out the problem is with the new and improved security settings. The simple solution was to remove the security settings for the folder the file was in. After removing the security settings; the macro ran perfect and we did not need to install mscal.ocx.
Unfortunately I do not have access to Windows 7 any more and I cannot recall the exact steps but the way I found the path to unlock the folder was by attempting to run another Excel file with a simpler macro that does not require mscal.ocx. The ensuing error in that case specified the real reason and provided a link explaining how to change the security settings.
I hope that helps,
Paul
%systemroot%SysWoW64regsvr32 mscal.ocx
I don(t know why it’s ok but i tried it after i read this and it’s working ?? : http://support.microsoft.com/kb/249873
Re moi..
Sorry, I didn’t say Hello ! and Bye… sorry I don(t speak english very well !
See You
Bye
I made my own calendar control as a VBA form. I found I could not use MSCAL.ocx for my 64 bit clients. You are welcome to give it a try.
I posted it at my web site at http://www.ssitools.com. Go to Software Tools, Free Downloads.
Gary Arnold
Structured Solutions Inc.
480 650-1605