DTPicker - DatePicker

[AlanAnderson]

Hi,
I have two machines, both with XP and Office Professional 2003.

On one I am able to run Excel with Macros that use ms DTPicker.
On the other I cant and when I try to add it through "Additional Controls" it is not on the list at all.

My questions:

1. Can I copy the file (belive its called mscomct.ocx) from one machine to other?
2. Where is this file. I can't find it using a search - it's probably inside another file.

Regards,

Alan

PS I hope this is the correct forum for this question.

 

[RoryA]

The ocx is usually in C:\Windows\system32.
Are you using the same file on both machines?

 

[AlanAnderson]

Hi Rory,
I found file in System32 - Thanks for that.

However if I copy it accross to other machine (same location) the "Additional Controls" facility still does not see it.

Any ideas??

Thanks,

Alan

 

[RoryA]

Did you register it using regsvr32?

 

[AlanAnderson]

No. How would I do that?

Sorry to be so dense.

Thanks,

Alan

 

[RoryA]

Open a command prompt (start-run type 'cmd' without the quotes then enter), then type:
c:
then press Enter. Then type:
CD C:\Windows\system32
and press enter, then type:
regsvr32 mscomctl.ocx
and press enter.

 

[AlanAnderson]

Rory, Thank you SOOOOOOO much. You are a champion.

Thanks,

Alan

 

[RoryA]

Glad to help.