DatePicker control lost in Excel 2007

  • Thread starter Thread starter Lemi
  • Start date Start date
L

Lemi

Hello,

I had a macro written in Office XP (Excel 2002). In a user form I had used a
date control adding it from the "Additional controls" button..

Now I try to run it on Excel 2007 but it gives an error. Because the
DatePicker control in the userform is lost. I cannot add it because it does
not exist in the list of Additional Controls. I use a 60 day-trial version
of Office 2007, could it be the reason? Otherwise how can I get it work
again? I can send my file if it would help.

Thanks
Lemi
 
Hi Lemi

The control is a part of Access so if you not have this you not have the control
 
Hi Lemi,

I have a full version of Office 2007 and there is no Calendar control, I
think I once heard that it is now shipped with MS Access, and there is a
place on the web where you should be able to download the calendar library,
I just don't remember where, have a search on Google for: "calendar control
library".
In any case do check the references list of libraries it might already be on
your computer just you need to reference it.

Hope this helps
 
Hi Lemi,

I have a full version of Office 2007 and there is no Calendar control, I
think I once heard that it is now shipped with MS Access, and there is a
place on the web where you should be able to download the calendar library,
I just don't remember where, have a search on Google for: "calendar control
library".
In any case do check the references list of libraries it might already beon
your computer just you need to reference it.

Hope this helps









- Show quoted text -
Click to expand...

If you have full office 2007, Microsoft Date and Time control version
6.0 is available under additinal controls located at C:\windows
\system32\mscomct2.ocx.
If not listed under additional controls, you can manually register it
and use the same.

Regards,
Madiya
 
Thank you all for your help.
I have first tried Howard31's suggestion. Google search ended up in
comctl32.dll ver 5.82 for XP which is already installed under
"windows\system32".

Madiya, I have the file "C:\windows\system32\mscomctl.ocx" but can you
please tell me how to manually register it?

If it is related to MS Access in the end as Ron de Bruin and Howard31 have
mentioned then I have to be sure that my macro file would work before I buy
the Office 2007 with Access. Otherwise I will stick to good old Office XP.
Would you make a test run in your computer if I send my file? It is a kind
of expense list generator to report the travel expenses.

Regards/Lemi

Hi Lemi,

I have a full version of Office 2007 and there is no Calendar control, I
think I once heard that it is now shipped with MS Access, and there is a
place on the web where you should be able to download the calendar
library,
I just don't remember where, have a search on Google for: "calendar
control
library".
In any case do check the references list of libraries it might already be
on
your computer just you need to reference it.

Hope this helps









- Show quoted text -
Click to expand...

If you have full office 2007, Microsoft Date and Time control version
6.0 is available under additinal controls located at C:\windows
\system32\mscomct2.ocx.
If not listed under additional controls, you can manually register it
and use the same.

Regards,
Madiya
 
Back
Top