jhs2000.xla

[Guest]

Hi -

I have developed a macro that utilizes several user forms and a calendar
control for users to input data. It works like a charm for users located at
US. However, the users located at Belgium are getting an error message,
"can't find object". I am able to nail down on the calendar control because
the users are able to execute the macros, open some of the forms. Yet,
whenever they are ready to click on the field that uses the calendar control
this message appears.

My first reaction is to ensure the calendar control is turn on. The only way
I know is to go to the personal.xls file - > Tool -> VBE -> Tools ->
References -> click on Calendar control 9.0. However, my user at Belgium
said he does not have personal.xls file, but has jhs2000.xla in his excel
application holder.

Are they the same file but with different name? Also, other ways to resolve
this problem? because for the users at the US, I did not do anthing with
their set up and they are able to run this macro without any problem.
Any advices greatly appreciate.

Kathy

 

[Jim Rech]

The calendar control is an optional component that is actually part of
Access. So, unlike you, your European users may not have a version of
Office that includes Access or, if they do, their IT people may not have
installed the component.

--
Jim Rech
Excel MVP
| Hi -
|
| I have developed a macro that utilizes several user forms and a calendar
| control for users to input data. It works like a charm for users located
at
| US. However, the users located at Belgium are getting an error message,
| "can't find object". I am able to nail down on the calendar control
because
| the users are able to execute the macros, open some of the forms. Yet,
| whenever they are ready to click on the field that uses the calendar
control
| this message appears.
|
| My first reaction is to ensure the calendar control is turn on. The only
way
| I know is to go to the personal.xls file - > Tool -> VBE -> Tools ->
| References -> click on Calendar control 9.0. However, my user at Belgium
| said he does not have personal.xls file, but has jhs2000.xla in his excel
| application holder.
|
| Are they the same file but with different name? Also, other ways to
resolve
| this problem? because for the users at the US, I did not do anthing with
| their set up and they are able to run this macro without any problem.
| Any advices greatly appreciate.
|
| Kathy