Calendar control

Todd_M · Apr 20th, 2002, 12:16 PM

I created a project in Excel 2000 using calendar control 9.0. I am now trying to run the program in Excel 2002 (XP) and messages that I am getting is that the calendar form is not available. When I go to add additional controls I can not find it in the list. Can I add a control in XP and if so where do I find this control. Thank you.

Tom Schreiner · Apr 20th, 2002, 12:35 PM

Hi Todd

Are you using this as an insertable object on a worksheet? Or as an active X control on a userform?

Tom

Todd_M · Apr 20th, 2002, 12:38 PM

Active X control on a user form. Thank you.

Tom Schreiner · Apr 20th, 2002, 12:52 PM

I have 2000, but I would assume that the control would be standard in XP?
I will help you the best that I can...

You said that the calendar was not in the list of additional controls?

First of all search your system folder for MSCAL.OCX by trying to set a reference to the control from tools, references...

Make sure the file type filter is selected for ".ocx"

You should not need to do this, but?
Anyway, see if you even have the file.

Tom

Todd_M · Apr 20th, 2002, 01:01 PM

All my .ocx files are in the system32 dir as I am running windows 2000 but the mscal.ocx is not there. I do not have it at all on my machine. Thanks again.

Tom Schreiner · Apr 20th, 2002, 01:03 PM

I have to run...
Someone will be able to help you.
For now, if the file "mscal.ocx" does not exist in your system folder, check your office folder as well.
If the file does exist but is not registered, then click on run and type this in the textbox...

regsvr32 mscal.ocx

Click Ok.
Should register the control.
Hope I was able to help you.
Tom

Todd_M · Apr 20th, 2002, 03:44 PM

Thanks Tom. You got me going in the right direction. I found on on the web the latest copy of mscal.ocx and then extracted it to my winntsystem32 dir and then ran the regsvr32.exe c:winntsystem32mscal.ocx and then my problems were over. Thanks again. Todd.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 20th, 2002, 12:16 PM	#1
Todd_M Board Regular Join Date: Feb 2002 Posts: 117	I created a project in Excel 2000 using calendar control 9.0. I am now trying to run the program in Excel 2002 (XP) and messages that I am getting is that the calendar form is not available. When I go to add additional controls I can not find it in the list. Can I add a control in XP and if so where do I find this control. Thank you.

Apr 20th, 2002, 12:35 PM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi Todd Are you using this as an insertable object on a worksheet? Or as an active X control on a userform? Tom

Apr 20th, 2002, 12:38 PM	#3
Todd_M Board Regular Join Date: Feb 2002 Posts: 117	Active X control on a user form. Thank you.

Apr 20th, 2002, 12:52 PM	#4
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	I have 2000, but I would assume that the control would be standard in XP? I will help you the best that I can... You said that the calendar was not in the list of additional controls? First of all search your system folder for MSCAL.OCX by trying to set a reference to the control from tools, references... Make sure the file type filter is selected for ".ocx" You should not need to do this, but? Anyway, see if you even have the file. Tom

Apr 20th, 2002, 01:01 PM	#5
Todd_M Board Regular Join Date: Feb 2002 Posts: 117	All my .ocx files are in the system32 dir as I am running windows 2000 but the mscal.ocx is not there. I do not have it at all on my machine. Thanks again.

Apr 20th, 2002, 01:03 PM	#6
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	I have to run... Someone will be able to help you. For now, if the file "mscal.ocx" does not exist in your system folder, check your office folder as well. If the file does exist but is not registered, then click on run and type this in the textbox... regsvr32 mscal.ocx Click Ok. Should register the control. Hope I was able to help you. Tom

Apr 20th, 2002, 03:44 PM	#7
Todd_M Board Regular Join Date: Feb 2002 Posts: 117	Thanks Tom. You got me going in the right direction. I found on on the web the latest copy of mscal.ocx and then extracted it to my winntsystem32 dir and then ran the regsvr32.exe c:winntsystem32mscal.ocx and then my problems were over. Thanks again. Todd.