DTPicker Not available causing error

[djsouljah]

Hi guys,

I have a worksheet with a userform that uses the DTpicker in it and it works fine on my machine but on others it doesn't seam to be able to find the DTpicker object as it's causing an error on load "IMPOSSIBLE TO LOAD OBJECTS AS THEY ARE NOT AVAILABLE ON THIS MACHINE"... By reading online, if i understood correctly, the DTPicker is installed with Microsoft Access and it could be the reason as on the machine that it's not working, there isn't microsoft access installed in it.... Can you guys help me find an alternative where i wouldn't be obliged to use TextBoxes?

Thanks a buch!

[contaminated]

DTpicker feature is not available on 2007 and higher by default, and thus, every user, who will use you spreadsheet must register MSCOMCT2.OCX in his system from elevated command prompt like below

1. Regsvr32 c:\windows\system32\MSCOMCT2.OCX for x32 Excel
2. Regsvr32 c:\windows\SYSWOW64\MSCOMCT2.OCX if they run x64 version of Excel.

Of course they must first download MSCOMCT2.OCX file and copy it to appropriate directory depending on version of Excel they use

[djsouljah]

Thank you for your fast reply..

When regestering the ocx file I'm getting an error 0x8002801c..

What does that mean and what can I do ? (Please note that on these machines, I don't have administrator access)

[jaslake]

Hi djsouljah

Please see this link for several alternatives to Date Picker

http://www.excelforum.com/excel-prog...placement.html

[contaminated]

The error value 0x8002801c means, Error accessing the OLE (Object Linking and Embedding) registry. You need to copy the MSCOMCT2.OCX file to c:\windows\sysWOW64 not c:\windows\system32.

Run the command with elevated privileges, to do this, follow the steps below:

1. Click on start and in the start search bar type CMD, right click on the command prompt icon in the programs area and then click on run as administrator.
2. At the command prompt type regsvr32 wmnetmgr.dll and then press enter.

Note: Make sure you are running the computer as administrator. Make sure you have logged in as administrator of the computer