Help to get Calander functions on Excel XP
 

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,
--
Les Hay, Livingston. Scotland

Help to get Calander functions on Excel XP
 

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.



On Sat, 2 Aug 2003 20:06:18 -0400, "Tom Ogilvy"
wrote:

Excel doesn't have any built in "Calendar stuff".

Did you use the calendar control? This is distributed with Access I
believe.

You would need to install it on the target machine, or if that machine
contains a later version, create a reference to it.

Another possible solution (if it is there) is to use late binding.

Regards,
Tom Ogilvy


Les wrote in message
...
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,
--
Les Hay, Livingston. Scotland

Help to get Calander functions on Excel XP
 

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,
--
Les Hay, Livingston. Scotland
"Random" <Random@nwhere wrote in message
...
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.



On Sat, 2 Aug 2003 20:06:18 -0400, "Tom Ogilvy"

wrote:

Excel doesn't have any built in "Calendar stuff".

Did you use the calendar control? This is distributed with
Access I
believe.

You would need to install it on the target machine, or if that
machine
contains a later version, create a reference to it.

Another possible solution (if it is there) is to use late
binding.

Regards,
Tom Ogilvy


Les wrote in message
...
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,
--
Les Hay, Livingston. Scotland

Help to get Calander functions on Excel XP
 

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


"Les" wrote in message
...
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,
--
Les Hay, Livingston. Scotland
"Random" <Random@nwhere wrote in message
...
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.



On Sat, 2 Aug 2003 20:06:18 -0400, "Tom Ogilvy"

wrote:

Excel doesn't have any built in "Calendar stuff".

Did you use the calendar control? This is distributed with
Access I
believe.

You would need to install it on the target machine, or if
that
machine
contains a later version, create a reference to it.

Another possible solution (if it is there) is to use late
binding.

Regards,
Tom Ogilvy


Les wrote in message
...
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,
--
Les Hay, Livingston. Scotland

Help to get Calander functions on Excel XP
 

Hi Chip

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

regards,
--
Les Hay, Livingston. Scotland
"Chip Pearson" wrote in message
...
"C:\Path\mscal.ocx" /RegServer

Nope. Use

RegSvr32 "C:\Path\mscal.ocx"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Chip Pearson" wrote in message
...
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


"Les" wrote in message
...
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,
--
Les Hay, Livingston. Scotland

Help to get Calander functions on Excel XP
 

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,
--
Les Hay, Livingston. Scotland
"Chip Pearson" wrote in message
...
"C:\Path\mscal.ocx" /RegServer

Nope. Use

RegSvr32 "C:\Path\mscal.ocx"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Chip Pearson" wrote in message
...
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


"Les" wrote in message
...
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,
--
Les Hay, Livingston. Scotland