PDA

View Full Version : Embed ActiveX Control for portability



JimmyTheHand
02-20-2007, 08:29 AM
Hi All :hi:

My problem is:
I'm creating an Excel application that uses Calendar Control (MSCAL.OCX) Test version works fine at home, but would not run in my office, because that PC doesn't have MSCAL.OCX installed. The application is intended for a nonprofit organization, which has a dozen computers in a network, and any of them should be capable of running my macros.

Can I somehow embed/include/whatever MSCAL.OCX into the final .xls, so that my application would be portable, and work, no matter what the hosting PC's environment is? Or do I have to install and register MSCAL.OCX on every single PC?

A second question. I make the application in Excel 2003. On the other hand, the tartget computers have a mix of versions 2000 and 2002 installed. If I have to install and register MSCAL.OCX on each computers, I'm almost sure it has to be the exact same file I used (version 11.0.6550.0), which is for Office 2003. Should I expect version conflicts with Office 2000 and 2002?

Thanks for all help, hints and guidance

Jimmy

lucas
02-20-2007, 08:35 AM
Hi Jimmy,
This is an ongoing problem with portability with the calendar control. Search the forums for solutions as it has been discussed extensivly. If your using the calendar control to add dates to a worksheet you might try this kb entry:
http://vbaexpress.com/kb/getarticle.php?kb_id=543
The advantage is that it is as portable as any userform.

lucas
02-20-2007, 08:45 AM
Jimmy,
Here is one thread that deals with the problem.
http://www.vbaexpress.com/forum/showthread.php?t=10914