My Apologies
 

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




-----Original Message-----
Sisilla,

Again, please don't post the same questions in multiple
groups.
I posted a reply to your post in .newusers

Take a look here for hints and tips on posting to the
ng's:
http://www.CPearson.com/excel/newposte.htm
http://www.mvps.org/dmcritchie/excel/posting.htm

John

Sisilla wrote:

Microsoft Date/Time Picker (MSCOMCTZ.OCX)is a userform
control tool on Office 97. What is its equivalent on
Office XP? My Office XP users are receiving error
messages
because this tool has not been loaded on their
machines. I
can't understand why Microsoft would remove this as a
standard tool on Office XP. I appreciate any help.

.

My Apologies
 

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

Sisilla

-----Original Message-----
Sisilla,

Apologies are not necessary.
We're here to help and we enjoy doing so.
Most newcomers to the group make the same mistakes.
Take a look at the links to the sites that I gave you and
let me extend a welcome to the the newsgroup community.

John

Sisilla wrote:

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

-----Original Message-----
Sisilla,

Again, please don't post the same questions in multiple
groups.
I posted a reply to your post in .newusers

Take a look here for hints and tips on posting to the
ng's:
http://www.CPearson.com/excel/newposte.htm
http://www.mvps.org/dmcritchie/excel/posting.htm

John

Sisilla wrote:

Microsoft Date/Time Picker (MSCOMCTZ.OCX)is a
userform
control tool on Office 97. What is its equivalent on
Office XP? My Office XP users are receiving error
messages
because this tool has not been loaded on their
machines. I
can't understand why Microsoft would remove this as a
standard tool on Office XP. I appreciate any help.

.


.

My Apologies
 

Being a wise guy? Hard to tell.

"Sisilla" wrote in message
...
Sorry about apologizing so much. I am easily disturbed,
and apologizing gives me peace of mind and restful nights.

Sisilla

-----Original Message-----
Sisilla,

Apologies are not necessary.
We're here to help and we enjoy doing so.
Most newcomers to the group make the same mistakes.
Take a look at the links to the sites that I gave you and
let me extend a welcome to the the newsgroup community.

John

Sisilla wrote:

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

-----Original Message-----
Sisilla,

Again, please don't post the same questions in multiple
groups.
I posted a reply to your post in .newusers

Take a look here for hints and tips on posting to the
ng's:
http://www.CPearson.com/excel/newposte.htm
http://www.mvps.org/dmcritchie/excel/posting.htm

John

Sisilla wrote:

Microsoft Date/Time Picker (MSCOMCTZ.OCX)is a
userform
control tool on Office 97. What is its equivalent on
Office XP? My Office XP users are receiving error
messages
because this tool has not been loaded on their
machines. I
can't understand why Microsoft would remove this as a
standard tool on Office XP. I appreciate any help.

.


.

My Apologies
 

Richard,

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

John


Richard Choate wrote:

Being a wise guy? Hard to tell.

"Sisilla" wrote in message
...
Sorry about apologizing so much. I am easily disturbed,
and apologizing gives me peace of mind and restful nights.

Sisilla

-----Original Message-----
Sisilla,

Apologies are not necessary.
We're here to help and we enjoy doing so.
Most newcomers to the group make the same mistakes.
Take a look at the links to the sites that I gave you and
let me extend a welcome to the the newsgroup community.

John

Sisilla wrote:

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

-----Original Message-----
Sisilla,

Again, please don't post the same questions in multiple
groups.
I posted a reply to your post in .newusers

Take a look here for hints and tips on posting to the
ng's:
http://www.CPearson.com/excel/newposte.htm
http://www.mvps.org/dmcritchie/excel/posting.htm

John

Sisilla wrote:

Microsoft Date/Time Picker (MSCOMCTZ.OCX)is a
userform
control tool on Office 97. What is its equivalent on
Office XP? My Office XP users are receiving error
messages
because this tool has not been loaded on their
machines. I
can't understand why Microsoft would remove this as a
standard tool on Office XP. I appreciate any help.

.


.

My Apologies
 

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=e...t.public.excel

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

John

Sisilla wrote:

Richard,

Thanks for your efforts to help me. I am new to both Excel
and VB; how would I go about installing the date/time
picker tool on individual machines, and is there any way
to automate the installation when the spreadsheet is
opened? I appreciate any further advice.

Again Thanks,
Sisilla

-----Original Message-----
Being a wise guy? Hard to tell.

"Sisilla" wrote in message
...
Sorry about apologizing so much. I am easily disturbed,
and apologizing gives me peace of mind and restful nights.

Sisilla

-----Original Message-----
Sisilla,

Apologies are not necessary.
We're here to help and we enjoy doing so.
Most newcomers to the group make the same mistakes.
Take a look at the links to the sites that I gave you and
let me extend a welcome to the the newsgroup community.

John

Sisilla wrote:

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

-----Original Message-----
Sisilla,

Again, please don't post the same questions in
multiple
groups.
I posted a reply to your post in .newusers

Take a look here for hints and tips on posting to the
ng's:
http://www.CPearson.com/excel/newposte.htm
http://www.mvps.org/dmcritchie/excel/posting.htm

John

Sisilla wrote:

Microsoft Date/Time Picker (MSCOMCTZ.OCX)is a
userform
control tool on Office 97. What is its equivalent on
Office XP? My Office XP users are receiving error
messages
because this tool has not been loaded on their
machines. I
can't understand why Microsoft would remove this as
a
standard tool on Office XP. I appreciate any help.

.


.



.

My Apologies
 

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



"Sisilla" wrote in message
...
Hey John,

I certainly appreciate your response here. I believe that
your perception of and faith in others are reflective of
your own personality. Thank you for your understanding.

Back to my original question: I have seen some options for
downloading mscomctz.ocx. Could you give me step by step
instructions for its installation? I think I might have
downloaded it, but when I try to run it, I am prompted to
open it with a file (that I must specify). I know that
this must all be very basic to you. Please keep in mind
that I am very knew to this kind of stuff. I appreciate
any further advice.

Again Thanks,
Sisilla

-----Original Message-----
Richard,

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

John


Richard Choate wrote:

Being a wise guy? Hard to tell.

"Sisilla" wrote in message
...
Sorry about apologizing so much. I am easily disturbed,
and apologizing gives me peace of mind and restful
nights.

Sisilla

-----Original Message-----
Sisilla,

Apologies are not necessary.
We're here to help and we enjoy doing so.
Most newcomers to the group make the same mistakes.
Take a look at the links to the sites that I gave you
and
let me extend a welcome to the the newsgroup community.

John

Sisilla wrote:

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

-----Original Message-----
Sisilla,

Again, please don't post the same questions in
multiple
groups.
I posted a reply to your post in .newusers

Take a look here for hints and tips on posting to
the
ng's:
http://www.CPearson.com/excel/newposte.htm
http://www.mvps.org/dmcritchie/excel/posting.htm

John

Sisilla wrote:

Microsoft Date/Time Picker (MSCOMCTZ.OCX)is a
userform
control tool on Office 97. What is its equivalent
on
Office XP? My Office XP users are receiving error
messages
because this tool has not been loaded on their
machines. I
can't understand why Microsoft would remove this
as a
standard tool on Office XP. I appreciate any help.

.


.


.

My Apologies
 

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

Sisilla wrote:

Chip,

Thank you for your efforts to help me. I did successfully
register the control using the directions you gave me,
but "Microsoft Date/Time Picker" is still not an option in
my Control Toolbox when I open Visual Basic Editor, and
when I try to open an Excel document that contains the
Date/Time Picker I receive a message as follows:

Could not load some objects because they are not available
on this machine.

The VB editor then opens up, prompting me to debug:

Compile error: Can't find project or library.

Private Sub Workbook_Open()
With Application
.ScreenUpdating = False
.Cursor = xlWait
.StatusBar = "Initializing..."
End With
WorkbookName = ActiveWorkbook.Name
If WorkbookName = "Complaints Analysis.xls" Then
ResetCriteria
ConnectDatabase
WhoIsThis UserName
Range("UserName").Value = UserName
LogEntry
LoadMills
LoadSalesReps
LoadCSRs
LoadPrimarySalesReps
LoadQualityReps
LoadCountries
LoadStates ""
End If
ActivateSheet
End Sub

I appreciate any further advice.

Again Thanks,
Sisilla

-----Original Message-----
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



"Sisilla" wrote in message
...
Hey John,

I certainly appreciate your response here. I believe
that
your perception of and faith in others are reflective of
your own personality. Thank you for your understanding.

Back to my original question: I have seen some options
for
downloading mscomctz.ocx. Could you give me step by step
instructions for its installation? I think I might have
downloaded it, but when I try to run it, I am prompted
to
open it with a file (that I must specify). I know that
this must all be very basic to you. Please keep in mind
that I am very knew to this kind of stuff. I appreciate
any further advice.

Again Thanks,
Sisilla

-----Original Message-----
Richard,

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

John


Richard Choate wrote:

Being a wise guy? Hard to tell.

"Sisilla" wrote in message
...
Sorry about apologizing so much. I am easily
disturbed,
and apologizing gives me peace of mind and restful
nights.

Sisilla

-----Original Message-----
Sisilla,

Apologies are not necessary.
We're here to help and we enjoy doing so.
Most newcomers to the group make the same mistakes.
Take a look at the links to the sites that I gave
you
and
let me extend a welcome to the the newsgroup
community.

John

Sisilla wrote:

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

-----Original Message-----
Sisilla,

Again, please don't post the same questions in
multiple
groups.
I posted a reply to your post in .newusers

Take a look here for hints and tips on posting to
the
ng's:
http://www.CPearson.com/excel/newposte.htm
http://www.mvps.org/dmcritchie/excel/posting.htm

John

Sisilla wrote:

Microsoft Date/Time Picker (MSCOMCTZ.OCX)is a
userform
control tool on Office 97. What is its
equivalent
on
Office XP? My Office XP users are receiving
error
messages
because this tool has not been loaded on their
machines. I
can't understand why Microsoft would remove
this
as a
standard tool on Office XP. I appreciate any
help.

.


.


.



.

My Apologies
 

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 wrote:

Hi John,

No it is not. May be I need to download it again? What do
you suggest?

Thanks,
Sisilla

-----Original Message-----
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

Sisilla wrote:

Chip,

Thank you for your efforts to help me. I did
successfully
register the control using the directions you gave me,
but "Microsoft Date/Time Picker" is still not an option
in
my Control Toolbox when I open Visual Basic Editor, and
when I try to open an Excel document that contains the
Date/Time Picker I receive a message as follows:

Could not load some objects because they are not
available
on this machine.

The VB editor then opens up, prompting me to debug:

Compile error: Can't find project or library.

Private Sub Workbook_Open()
With Application
.ScreenUpdating = False
.Cursor = xlWait
.StatusBar = "Initializing..."
End With
WorkbookName = ActiveWorkbook.Name
If WorkbookName = "Complaints Analysis.xls" Then
ResetCriteria
ConnectDatabase
WhoIsThis UserName
Range("UserName").Value = UserName
LogEntry
LoadMills
LoadSalesReps
LoadCSRs
LoadPrimarySalesReps
LoadQualityReps
LoadCountries
LoadStates ""
End If
ActivateSheet
End Sub

I appreciate any further advice.

Again Thanks,
Sisilla

-----Original Message-----
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



"Sisilla" wrote in message
...
Hey John,

I certainly appreciate your response here. I believe
that
your perception of and faith in others are
reflective of
your own personality. Thank you for your
understanding.

Back to my original question: I have seen some
options
for
downloading mscomctz.ocx. Could you give me step by
step
instructions for its installation? I think I might
have
downloaded it, but when I try to run it, I am
prompted
to
open it with a file (that I must specify). I know
that
this must all be very basic to you. Please keep in
mind
that I am very knew to this kind of stuff. I
appreciate
any further advice.

Again Thanks,
Sisilla

-----Original Message-----
Richard,

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

John


Richard Choate wrote:

Being a wise guy? Hard to tell.

"Sisilla" wrote in message
...
Sorry about apologizing so much. I am easily
disturbed,
and apologizing gives me peace of mind and restful
nights.

Sisilla

-----Original Message-----
Sisilla,

Apologies are not necessary.
We're here to help and we enjoy doing so.
Most newcomers to the group make the same
mistakes.
Take a look at the links to the sites that I gave
you
and
let me extend a welcome to the the newsgroup
community.

John

Sisilla wrote:

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

-----Original Message-----
Sisilla,

Again, please don't post the same questions in
multiple
groups.
I posted a reply to your post in .newusers

Take a look here for hints and tips on
posting to
the
ng's:
http://www.CPearson.com/excel/newposte.htm

http://www.mvps.org/dmcritchie/excel/posting.htm

John

Sisilla wrote:

Microsoft Date/Time Picker (MSCOMCTZ.OCX)is
a
userform
control tool on Office 97. What is its
equivalent
on
Office XP? My Office XP users are receiving
error
messages
because this tool has not been loaded on
their
machines. I
can't understand why Microsoft would remove
this
as a
standard tool on Office XP. I appreciate any
help.

.


.


.



.


.

My Apologies
 

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

-----Original Message-----
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 wrote:

Hi John,

No it is not. May be I need to download it again? What
do
you suggest?

Thanks,
Sisilla

-----Original Message-----
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

Sisilla wrote:

Chip,

Thank you for your efforts to help me. I did
successfully
register the control using the directions you gave
me,
but "Microsoft Date/Time Picker" is still not an
option
in
my Control Toolbox when I open Visual Basic Editor,
and
when I try to open an Excel document that contains
the
Date/Time Picker I receive a message as follows:

Could not load some objects because they are not
available
on this machine.

The VB editor then opens up, prompting me to debug:

Compile error: Can't find project or library.

Private Sub Workbook_Open()
With Application
.ScreenUpdating = False
.Cursor = xlWait
.StatusBar = "Initializing..."
End With
WorkbookName = ActiveWorkbook.Name
If WorkbookName = "Complaints Analysis.xls" Then
ResetCriteria
ConnectDatabase
WhoIsThis UserName
Range("UserName").Value = UserName
LogEntry
LoadMills
LoadSalesReps
LoadCSRs
LoadPrimarySalesReps
LoadQualityReps
LoadCountries
LoadStates ""
End If
ActivateSheet
End Sub

I appreciate any further advice.

Again Thanks,
Sisilla

-----Original Message-----
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



"Sisilla" wrote in message
...
Hey John,

I certainly appreciate your response here. I
believe
that
your perception of and faith in others are
reflective of
your own personality. Thank you for your
understanding.

Back to my original question: I have seen some
options
for
downloading mscomctz.ocx. Could you give me step
by
step
instructions for its installation? I think I might
have
downloaded it, but when I try to run it, I am
prompted
to
open it with a file (that I must specify). I know
that
this must all be very basic to you. Please keep in
mind
that I am very knew to this kind of stuff. I
appreciate
any further advice.

Again Thanks,
Sisilla

-----Original Message-----
Richard,

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

John


Richard Choate wrote:

Being a wise guy? Hard to tell.

"Sisilla" wrote in
message
...
Sorry about apologizing so much. I am easily
disturbed,
and apologizing gives me peace of mind and
restful
nights.

Sisilla

-----Original Message-----
Sisilla,

Apologies are not necessary.
We're here to help and we enjoy doing so.
Most newcomers to the group make the same
mistakes.
Take a look at the links to the sites that I
gave
you
and
let me extend a welcome to the the newsgroup
community.

John

Sisilla wrote:

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

-----Original Message-----
Sisilla,

Again, please don't post the same
questions in
multiple
groups.
I posted a reply to your post in .newusers

Take a look here for hints and tips on
posting to
the
ng's:
http://www.CPearson.com/excel/newposte.htm

http://www.mvps.org/dmcritchie/excel/posting.htm

John

Sisilla wrote:

Microsoft Date/Time Picker (MSCOMCTZ.OCX)
is
a
userform
control tool on Office 97. What is its
equivalent
on
Office XP? My Office XP users are
receiving
error
messages
because this tool has not been loaded on
their
machines. I
can't understand why Microsoft would
remove
this
as a
standard tool on Office XP. I appreciate
any
help.

.


.


.



.


.


.

My Apologies
 

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

Sisilla wrote:

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