My Apologies

[Sisilla]

I do beg your forgiveness, kind sir. You must allow for my
ignorance; I am but a mere intern and newsgroups are a
novelty to my inferior mentality. I shall endeavour, in
the future, to please you better.

Sisilla

 

[Sisilla]

Sorry about apologizing so much. I am easily disturbed,
and apologizing gives me peace of mind and restful nights.

Sisilla

 

[Richard Choate]

Being a wise guy? Hard to tell.

Sorry about apologizing so much. I am easily disturbed,
and apologizing gives me peace of mind and restful nights.

Sisilla

 

[John Wilson]

Richard,

Being a wise guy?

I don't think so.
Rec'd a direct reply and I believe it to be sincere.

John

 

[John Wilson]

Sisilla,

There may be some issues with licensing and/or distributing it
with your workbooks. Not sure though.
Check Google:
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&group=microsoft.public.excel

and search for "install date time picker"
for more information.

John

 

[Chip Pearson]

Sisilla,

If you have the file on the PC, you need to register that control
with Windows. This causes the control to write a ton of
information to the system registry describing itself, its
location, the location of its type library, and so on.

To do this, go to the Windows Start menu, choose Run, and enter

RegSvr32 C:\whatever\mscomctz.ocx

where C:\whatever is the appropriate path to the file.


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

 

[John Wilson]

Sisilla,

From the VB Editor, when you right click on the Toolbox
and then click "Additional Controls" is it not on the list
with an "x" next to it??

John

 

[John Wilson]

Sisilla,

You could try downloading it again but if you already did
before, it should be there on your computer.
One way or the other, when you do find/download it,
place it in it's own subdirectory (like C:\DateTime\mscomctz.ocx)
Then taking Chip's instructions, from the Start/Run menu,
type in:
RegSvr32 C:\DateTime\mscomctz.ocx

Once it's registered from the above line, reboot (maybe
not necessary, but wouldn't hurt) and see if it appears
in the "Additional Controls" on the VBE Toolbox.

John

 

[Sisilla]

Hey John,

You are terrific! Thank you so much. My problem was that I
had not moved the file, and when I was trying to register
it I typed in the wrong file name...one that did belong
there, so it gave me the "successful" message. After
reading your post, I realized that there was no way that I
could have successfully registered the file if I had not
moved it, and that is when I figured that I must have been
registering the wrong file! It's fixed now, but I posted a
new message about automating this installation...hope
someone replies!

Again Thanks,
Sisilla

 

[John Wilson]

Sisilla,

You're quite welcome.
Glad to have been a help.
Saw your other message in the ng.
I'm sure you'll get some answers to it.
Did you ever search Google with the links I gave you in
a previous post? Every question and answer that anyone
has ever posted in these ng's is archived there and your
question has been asked (and answered) before.
Also, you might try just searching all of the Google groups
for the text string "mscomctz.ocx" as it may turn up other
threads.

John