View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default automatically installing mscal.ocx

windows is XP Pro

That should have it. I have the same.
If you want to stick with MSCal.ocx then it would be
best to provide an installation package.
I use the free INNO installer and that is very good.

RBS

"Tim Marsh" wrote in message
s.com...
Ah, thanks. that explains the lack of control. my windows is XP Pro
Version 5.1.2600 Service Pack 2 Build 2600.

But in terms of moving on, i would still need a method of deployment
for whichever control I used (as mentioned previously) and as i've
already put it together using the mscal control, i would prefer to
keep with that. Any thoughts? In the meantime, i'll try and create
some code for it... if successful, i'll post back here.

Thanks for your continued patience!

Tim


On 8 Mar, 10:50, "RB Smissaert"
wrote:
Look at this one:http://support.microsoft.com/kb/297381

What is your windows version?

RBS

"Tim Marsh" wrote in message

oups.com...



Thanks for the reply RBS.


I've searched my c: drive and can't find 'MSComCt2.ocx' so it seems i
am in the same position as for the 'mscal.ocx', ie, even if i
downloaded MSComCt2.ocx i would still have to have some way of
deploying it / registering it etc etc (but please correct me if i'm
wrong)


Thanks,


Tim


PS - i did manage to find MSComCtl.ocx which i registered with windows
and added as a reference in the VBE but i didn't see any applicable
control that i could use as a result... any ideas?!


RB Smissaert wrote:


It is in MSComCt2.ocx Microsoft Windows Common Controls-2 6.0
So, just set a reference to it and add the control to the
control box.


RBS


"Tim" <tmarsh-trousers-@-take off my trousers to
reply-blueyonder.co.uk
wrote in ...
Hi,


I have a workbook that uses the calendar control, mscal.ocx; it
works
great! but i would like to distribute to various users some of which
are
unlikely to have that control registered or even installed on their
system. does anyone know of a way to automatically /
programatically: -
1) install the calendar control if its not present (in the right
location)
2) if not registered, register it (all systems will be windows xp)


i would want this to run before opening the workbook. and it would
have
to be simple installation (ie, i just say 'open workbook xxx' and it
all
installs automatically!


could i do it with vba in another workbook? if so, could someone
give
me
some pointers as to how i would do it?


Thanks for any help,


Tim- Hide quoted text -


- Show quoted text -