VBA Form with Calendar Control - Excel 2002 to 2003 compatibility

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TRE - 08 Oct 2008 06:18 GMT

I've developed, in Excel 2002, a VBA form that uses a Calendar Control
to pick dates.
On SOME Excel 2003 users in the office, but not all, they get an error
trying to load the program (it's a time-sheet program), which says
that an object is unavailable.

From some research to date I have a sense that the issue lies with
references made to Office 10.0 and Excel 10.0 Object Libraries on my
2002 version, and perhaps the calendar control is different in the
11.0 versions, but frankly, I'm getting out of my depth at that point.

Are there some key steps I can take to properly diagnose the
"unavailable object library" ? In particular, is there then an obvious
remedy. like copying some librayr file from my Excel 2002 PC to he
users' Excel 2003 (or 2007) PCs?

Reply to this Message

Barb Reinhardt - 08 Oct 2008 11:23 GMT

If it were me, I'd have a 2003 user look at their references in the VBE to
see what's missing as a starting point.

Signature

HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.

> I've developed, in Excel 2002, a VBA form that uses a Calendar Control
> to pick dates.
[quoted text clipped - 11 lines]
> remedy. like copying some librayr file from my Excel 2002 PC to he
> users' Excel 2003 (or 2007) PCs?

Reply to this Message

TRE - 08 Oct 2008 18:00 GMT

On Oct 8, 5:23 pm, Barb Reinhardt
<BarbReinha...@discussions.microsoft.com> wrote:

> If it were me, I'd have a 2003 user look at their references in the VBE to
> see what's missing as a starting point.
[quoted text clipped - 21 lines]
>
> - Show quoted text -

It seems that all the references are present, except that the
Microsoft Office 10.0 Object Librayr and Microsfot Excel 10.0 Object
Library are replaced with 11.0 equivalents.
There was also a Calendar Control 10.0 missing, but i've cpoied
something across (MSCAL.OCX?) and now got VBE claiming to know a
certain Calendar Control 11.0. But "copying across" might be some way
short of what's needed...this is where I'm out of my depth.
Cheers

Reply to this Message

Barb Reinhardt - 08 Oct 2008 19:26 GMT

This may help.

http://www.fontstuff.com/mailbag/qvba01.htm

Signature

HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.

> On Oct 8, 5:23 pm, Barb Reinhardt
> <BarbReinha...@discussions.microsoft.com> wrote:
[quoted text clipped - 32 lines]
> short of what's needed...this is where I'm out of my depth.
> Cheers

Reply to this Message

TRE - 10 Oct 2008 10:04 GMT

Thanks. This looks helpful. I'll give it a try as soon as I'm back in
the office.

On Oct 9, 1:26 am, Barb Reinhardt
<BarbReinha...@discussions.microsoft.com> wrote:

> This may help.
>
[quoted text clipped - 41 lines]
> > short of what's needed...this is where I'm out of my depth.
> > Cheers

Reply to this Message