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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Lemi" <(E-Mail Removed)> wrote in message news:%23eqFrmz$(E-Mail Removed)...
> 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,

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

"Lemi" <(E-Mail Removed)> wrote in message
news:%23eqFrmz$(E-Mail Removed)...
> 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
>

On Jul 8, 12:56*am, "Howard31" <iamamramcha...@hotmail.com> wrote:
> 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
>
> "Lemi" <lemioz...@superonline.com> wrote in message
>
> news:%23eqFrmz$(E-Mail Removed)...
>
>
>
> > 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 getit
> > work again? I can send my file if it would help.
>
> > Thanks
> > Lemi- Hide quoted text -
>
> - Show quoted text -

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

"Madiya" <(E-Mail Removed)> wrote in message
news:a321ff40-d350-4abc-85e8-(E-Mail Removed)...
On Jul 8, 12:56 am, "Howard31" <iamamramcha...@hotmail.com> wrote:
> 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
>
> "Lemi" <lemioz...@superonline.com> wrote in message
>
> news:%23eqFrmz$(E-Mail Removed)...
>
>
>
> > 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- Hide quoted text -
>
> - Show quoted text -

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