View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default How do I update calendar control 8.0 to 10.0

Hi Eric

It seems that the Control (8.0) for Excel 97 will not work on a sheet.
But It will work on a Userform in Excel 97.

When I run the Excel 97 file in Excel 2000-2003 it will not work on a sheet but is
working correct on a userform.

If you want then send me the file that is not workin correct in 2002



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Ron de Bruin" wrote in message ...
I checked it again and Excel 97 have version 8.0
You can download the controls here
(see the link on the bottem of this page)
http://www.rondebruin.nl/calendar.htm

I go try it in Excel 97 with 8.0 to see if I got problems when I
run it in a higher version.

I be back

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Eric" wrote in message ...
The version of Excel 2000 has calendar control 8.0 listed
when you select additional controls inside the VBA editor.
If you use Office XP which I have installed on another
machine it has calendar control 10.0 listed. The dll file
for both is named MSCAL.OCX which prevents me from having
both versions on the same machine. The calendar does not
display correctly in Office XP version of Excel.
-----Original Message-----
You say(8.0) Excel 2000 have 9.0????

I have try it with a control in 2000(9) and run it in 2003

(11)
and have no problems

What are the problem you have

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Eric" wrote in

message ...
I have an excel application I built using Excel 2000. I
used Calendar Controls on several of the forms. The
calendar controls in Office XP do not work properly with
the application built in Excel 2000. Is there a way to
either update all the calendar controls with the 10.0
control or have the application select an alternate
control depending on the version of office installed?


.