asked on

Trying to use the DTPicker Control in Excel

I have developed an Excel app that uses the DTPicker control which is part of mscomct2. When I distribute the app to other workstations, it will not load. I have run REGSVR32 C:\Windows\system\mscomct2.ocx successfully and even rebooted. I have even insured that the Microsoft Windows Common Controls is an active reference.

Any help or clues?

1William

On one of the troublesome pc's, did you open Access and confirm the active X control was available? What operating system(s) are you running?

jbugara

ASKER

I am attempting to run the application on some Win98 machines running Office 97.

1William

Just a confirmation,
<On one of the troublesome pc's, did you open Access and confirm the active X control was available? >

jbugara

ASKER

The application is driven from Excel and not Access. When I go into Excel and look at the References, I can see the Windows Common Controls as an active reference. However, when I then go to the Control Toolbox, I do not see the DTPicker control in the list of available controls. My understanding is that the DTPicker was part of MSCOMCT2.OCX which I thought was the Windows Common Controls.

ASKER CERTIFIED SOLUTION

1William

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

nexusnation

Hi jbugara,
This question has been abandoned and needs to be finalized (103 days since last comment).

You can accept an answer, split the points, or get a refund. Go to
http://www.cityofangels.com/Experts/Closing.htm for information and options.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

nexusnation
EE Cleanup Volunteer for Microsoft Access

1William

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept question, points to 1William (yeah, I know its' me, but I assure you, no favoritisim)
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

1William
EE Cleanup Volunteer