Hi,

I'm a complete beginner with xlVBA - hoping that this will be an easy
one for some kind soul to help me resolve.

I created a custom spreadsheet with three userforms, six or so modules,
dialog boxes and a calendar. Works perfectly well on my own pc at home.
Take it into work and again works perfectly. Take it to my friends
house, who I actually wrote the application for - and as soon as I try
to launch a form or draw the screen which contains the calendar object
I get the message about unable to find project or library.

All the machines run Excel 2003.

When I go to Tools/References the calendar control 11.0 object is
flagged as MISSING.

OK - so I need to install the calendar object into my friends copy of
xl. How do I do this?
Is it an option when xl is being installed? Please help.

Also, while playing around with this problem I see the export/import
files options - what do they do and could they help me here ( export
the object, then import it? ).

Apologies if this is too basic - I really am just starting out with
this and learning as I go.

Many thanks,

----------
krayten

Hi Krayten,

See the foot of Ron de Bruin's Calendar page:

http://www.rondebruin.nl/calendar.htm

---
Regards,
Norman



"krayten" wrote in message
oups.com...
Hi,

I'm a complete beginner with xlVBA - hoping that this will be an easy
one for some kind soul to help me resolve.

I created a custom spreadsheet with three userforms, six or so modules,
dialog boxes and a calendar. Works perfectly well on my own pc at home.
Take it into work and again works perfectly. Take it to my friends
house, who I actually wrote the application for - and as soon as I try
to launch a form or draw the screen which contains the calendar object
I get the message about unable to find project or library.

All the machines run Excel 2003.

When I go to Tools/References the calendar control 11.0 object is
flagged as MISSING.

OK - so I need to install the calendar object into my friends copy of
xl. How do I do this?
Is it an option when xl is being installed? Please help.

Also, while playing around with this problem I see the export/import
files options - what do they do and could they help me here ( export
the object, then import it? ).

Apologies if this is too basic - I really am just starting out with
this and learning as I go.

Many thanks,

----------
krayten

Hi Norman,

I now have a copy of the calendar control and information about how to
install it. On my pc's at home and at work I also have Access 2003.
Interestingly Access 2003 is not installed on my friends pc - this may
well be the source of the problem.

Hopefully I'll be able to get it to run now!
Many thanks,

-----------
krayten