I have made an Excel-VBA Project using a User Form with the DTPicker
Control.
Unfortunately this program does not work on the machines of the persons
who have to work with this program.
The Error Message: "Could not load an object because it is not
available on this machine" appears.

Can someone please help me to solve this problem?


--
H.A. de Wilde
------------------------------------------------------------------------
H.A. de Wilde's Profile: http://www.excelforum.com/member.php...o&userid=30679
View this thread: http://www.excelforum.com/showthread...hreadid=555512

Hello,

This topic may answer your problem:

http://groups.google.co.uk/group/mic...02c069cb9cf0fd

Hope this helps

Duncan


H. A. de Wilde wrote:

I have made an Excel-VBA Project using a User Form with the DTPicker
Control.
Unfortunately this program does not work on the machines of the persons
who have to work with this program.
The Error Message: "Could not load an object because it is not
available on this machine" appears.

Can someone please help me to solve this problem?


--
H.A. de Wilde
------------------------------------------------------------------------
H.A. de Wilde's Profile: http://www.excelforum.com/member.php...o&userid=30679
View this thread: http://www.excelforum.com/showthread...hreadid=555512

Dear Duncan,

thank you for your reply.
I hope our IT-department will install this file on the machines. Else
will be forced to use TextBoxes instead.

I found out that the file MscomctL.ocx is already installed. Do yo
know if it is possible to use the DTPicker (or something similar) fro
this file?

Kind regards,

hug

--
H.A. de Wild
-----------------------------------------------------------------------
H.A. de Wilde's Profile: http://www.excelforum.com/member.php...fo&userid=3067
View this thread: http://www.excelforum.com/showthread.php?threadid=55551

do you have a file called "dtpicker.exe" on your machine? small chance
this might just want adding to all users, if not you can always try
registering the other file by:

Try Windows Key + R
Then type Regsvr32 mscomctl.ocx and press enter

I am not entirely sure about using this control, I have run into
problems before and ended up using textboxes

Duncan


H.A. de Wilde wrote:

Dear Duncan,

thank you for your reply.
I hope our IT-department will install this file on the machines. Else I
will be forced to use TextBoxes instead.

I found out that the file MscomctL.ocx is already installed. Do you
know if it is possible to use the DTPicker (or something similar) from
this file?

Kind regards,

hugo


--
H.A. de Wilde
------------------------------------------------------------------------
H.A. de Wilde's Profile: http://www.excelforum.com/member.php...o&userid=30679
View this thread: http://www.excelforum.com/showthread...hreadid=555512

Hugo,
The DTPicker is part of mscomctl2.ocx. I have the idea that this is
installed with Access, but I may be completely wrong.

NickHK

"H.A. de Wilde"
wrote in message
news:H.A.de.Wilde.2a0s3q_1151342707.7707@excelforu m-nospam.com...

Dear Duncan,

thank you for your reply.
I hope our IT-department will install this file on the machines. Else I
will be forced to use TextBoxes instead.

I found out that the file MscomctL.ocx is already installed. Do you
know if it is possible to use the DTPicker (or something similar) from
this file?

Kind regards,

hugo


--
H.A. de Wilde
------------------------------------------------------------------------
H.A. de Wilde's Profile:
http://www.excelforum.com/member.php...o&userid=30679
View this thread: http://www.excelforum.com/showthread...hreadid=555512