Vba excel - Mscomct2.cab

Question

Morning, I've just trying to install date and time picker for vba, my problem is, once I've followed the instructions from support website, windows don't let me paste the file mscomct2 into the folder (windows\sysWOW64), so what's next?

Answer 1

Hi

After you installed ms office, that control should already be present in that directory.

To be able to add the date&Time picker object on a form you should first add it to your form toolbox.

Rght-click the toolbox and select "Additional controls ..." and scroll down until you can locate "Microsoft Date and Time Picker Control 6.0".

Verify first that you can do that, meaning that the control should already be present on your disk.

Regards

JY

Answer 2

No change. 

Microsoft Date Picker for Excel 2013 is still not there.

The Mscomct2.cab  file is still missing.

Office 2013 is validated and everything else seems to be operating fine.

Answer 3

I am working on Windows 10 Pro 64-bit

MS Office 2013

I have searched for Mscomct2.cab file and I'm unable to find it. 

After turning on Design Mode, More Controls is not visible.

I am unable to get Date Picker.

Answer 4

Hi

After you installed ms office, that control should already be present in that directory.

To be able to add the date&Time picker object on a form you should first add it to your form toolbox.

Rght-click the toolbox and select "Additional controls ..." and scroll down until you can locate "Microsoft Date and Time Picker Control 6.0".

Verify first that you can do that, meaning that the control should already be present on your disk.

Regards

JY

Thank you for your answer, but the reason of all of this is because I couldn't find "Microsoft Date and Time Picker Control 6.0" in the additional controls. That's why I was looking for the file mscomct2

Answer 5

HI

Be sure to unzip to another folder first before doing the copy paste of the control.

HTH

regards