jPat104
09-15-2005, 11:10 AM
Greetings,
I am getting ready to share out a workbook to 20 users that has a form, which displays dtpicker controls.
I discoverd that MS OFFICE PRO 2003 installs do not have mscomct2.ocx and when I opened the xls the form did not display the dtpickers. After installing/registering mscomct2.ocx into the sys32 folder and opening the xls again, the controls still do not appear. I had to add the control into the toolbox in the VBEditor then readd teh controls to the form in order to get the dtpickers to display.
My questions are:
Is this normal behavior?
Will I have to do the above procedure to everyones workstation, or do
you know if running a bat file that installs and registers mscomct2.ocx
prior to opening the the xls is sufficient?
I will not be able to test this out until next week, but need to make plans now if I have to visit each workstation personally.
Thanks for reading,
Patrick
I am getting ready to share out a workbook to 20 users that has a form, which displays dtpicker controls.
I discoverd that MS OFFICE PRO 2003 installs do not have mscomct2.ocx and when I opened the xls the form did not display the dtpickers. After installing/registering mscomct2.ocx into the sys32 folder and opening the xls again, the controls still do not appear. I had to add the control into the toolbox in the VBEditor then readd teh controls to the form in order to get the dtpickers to display.
My questions are:
Is this normal behavior?
Will I have to do the above procedure to everyones workstation, or do
you know if running a bat file that installs and registers mscomct2.ocx
prior to opening the the xls is sufficient?
I will not be able to test this out until next week, but need to make plans now if I have to visit each workstation personally.
Thanks for reading,
Patrick