Excel VBA Library

[dl]

I have an excel workbook with macros. This works fine on one machine but not
on another as an object library is not present for the basic function LCASE.
Can someone direct me on why as both machines use Excel 9. Any help would be
useful.

[NickHK]

dl,
The problem is probably not related to Excel directly, but a missing
reference to another component.
Check the References for one marked "Missing".

VB/VBA will through an error at any line if this is the case.

NickHK

"dl" <[email protected]> wrote in message
news:[email protected]...
> I have an excel workbook with macros. This works fine on one machine but
not
> on another as an object library is not present for the basic function
LCASE.
> Can someone direct me on why as both machines use Excel 9. Any help would
be
> useful.
>
>

[Mervb]

This is one of the things that reduces the usability of Excel - I have
applications that get distributed to different users on different machines
and (forgetting version differences) I could do the job a lot easier and
quicker if there was some way to use VBA to automatically reference these
libraries - or embed them (possibly blow out the file size dramaticaly).

Is there any way to do thid or is there a work around?

"NickHK" wrote:

> dl,
> The problem is probably not related to Excel directly, but a missing
> reference to another component.
> Check the References for one marked "Missing".
>
> VB/VBA will through an error at any line if this is the case.
>
> NickHK
>
> "dl" <[email protected]> wrote in message
> news:[email protected]...
> > I have an excel workbook with macros. This works fine on one machine but
> not
> > on another as an object library is not present for the basic function
> LCASE.
> > Can someone direct me on why as both machines use Excel 9. Any help would
> be
> > useful.
> >
> >
>
>
>