Error Msg "Cannot Load Object" when inserting DTPicker

[marts]

I am having several problems with the mscomct2.ocx for weeks now... See details below of the issue...

Details:
- No problem in inserting the DTPicker on the VBA environment / Form.
- Error message "Cannot Load Object" when I am trying to embed the DTPicker on a worksheet.
- I am currently using Excel 2003 (Just upgrade it from Excel 2002 due to mscomct2.ocx related problem).
- did the usual stuff...

1) regsvr32 /u c:\windows\system32\mscomct2.ocx​

2) downloaded the latest copy of mscomct2.ocx from Microsoft site.​

3) install using the *.inf file and it was copied to system32 folder.​

4) regsvr32 c:\windows\system32\mscomct2.ocx​

5) Still not able to insert the object to the worksheet​

- However I was able to load old excel files with existing embedded DTPicker but still not able to insert new one...

Did I miss anything that I should do? This is pretty odd and I can't move on from work and other things... Thanks...

 

[marts]

I am having several problems with the mscomct2.ocx for weeks now... See details below of the issue...

Details:
- No problem in inserting the DTPicker on the VBA environment / Form.
- Error message "Cannot Load Object" when I am trying to embed the DTPicker on a worksheet.
- I am currently using Excel 2003 (Just upgrade it from Excel 2002 due to mscomct2.ocx related problem).
- did the usual stuff...

1) regsvr32 /u c:\windows\system32\mscomct2.ocx​

2) downloaded the latest copy of mscomct2.ocx from Microsoft site.​

3) install using the *.inf file and it was copied to system32 folder.​

4) regsvr32 c:\windows\system32\mscomct2.ocx​

5) Still not able to insert the object to the worksheet​

- However I was able to load old excel files with existing embedded DTPicker but still not able to insert new one...

Did I miss anything that I should do? This is pretty odd and I can't move on from work and other things... Thanks...

Bump! Up!

Anyone?

 

[taurean]

There are some workarounds for the DatePicker control which you can get easily by googling.

I had once tried this calendar control in the past had some problems. The thread is here:
http://www.vbaexpress.com/forum/showthread.php?t=35548&highlight=design+time

Perhaps you should post this on msdn forums as well (with cross posting reference that is!)
http://social.msdn.microsoft.com/Forums/en-US/categories

 

[marts]

There are some workarounds for the DatePicker control which you can get easily by googling.

I had once tried this calendar control in the past had some problems. The thread is here:
http://www.vbaexpress.com/forum/showthread.php?t=35548&highlight=design+time

Perhaps you should post this on msdn forums as well (with cross posting reference that is!)
http://social.msdn.microsoft.com/Forums/en-US/categories

Hi Taurean,

Thanks for your reply and advise. Eventually I was not able to fix the issue with the DTPicker. But I was able to come up a workaround that I am fully satisfied. Actually this reminds me of the Spacepen vs Pencil story... hee hee...

See URL below for details of my workaround.

http://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/4157714d-efa0-47f1-9f7d-7840c351c567/?prof=required

 

[taurean]

Pain of uncommon errors. They just keep *****ing you badly. Happy that you found a solution.

On a passing note, The label on the screenshot you've posted on msdn says "Start End" which I guess should be "Start Date". But I could be wrong.

 

[marts]

Pain of uncommon errors. They just keep *****ing you badly. Happy that you found a solution.

On a passing note, The label on the screenshot you've posted on msdn says "Start End" which I guess should be "Start Date". But I could be wrong.

Haha! noted and already corrected! Thanks bro!