Help to get Calander functions on Excel XP

[Les]

Hi

I have just spent the best part of 2 weeks developing a small
project on my Excel 2000 which actually needs to run on Excel XP

Seems only one problem in the transfer - the XP version for some
reason doesn't have the calendar stuff on it!

What on earth do I need to do to get my project to work on XP?
Will the Calendar stuff from 2000 work on XP? If so, how would I
go about getting it transferred over?

Any pointers and/or help appreciated.

Right proper bummer when my wonderful, debugged application falls
over on first loading on the other machine - made me feel a proper
'expert' didn't it!

regards,

 

[Random]

If you are referring to the Calendar control, check for the existence
of mscal.ocx at c:\program files\microsoft office\office

That is the ActiveX control that needs to be registered in order to
utilize Microsoft's Calendar control.

 

[Les]

Hi

Thanks Tom and Random

I have located the mscal.ocx in my Office 2000 stuff, as per the
suggested path. Do I just need to transfer that file onto the
Office XP (same path if it exists)? Would I then need to use the
Add-in manager to 'register' it?

As can be seen, I am pretty much unaware of this side of things.

regards,

 

[Chip Pearson]

Les,

You need to register the control. Go to the Windows Start menu,
choose Run, and enter the following:
"C:\Path\mscal.ocx" /RegServer

where C:\Path is the full path to the file.



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[Les]

Hi Chip

Thanks for that. I will give it a go when next I can.

regards,

 

[Les]

Hi Chip

Thanks once again. I finally managed to apply your suggestions and
this solved the problem completely.

That's another pint I owe you.

regards,