Error trying to run Excel 2003 Add-in in Excel XP
 

Hi,

I wrote an Excel 2003 Add-in using VBA and distributed it to someone
using Excel XP (Excel 2003).

Whenever my client uses the app I am getting the following error when
the Mid function is encountered --

"Compile Error: Can't find project or library".

After I prepend the mid function with vba (so every instance of mid is
now vba.mid), the error goes away, but I'm wondering if all the
standard VBA functions will be affected in this manner and if there's
an easier resolution? Also I was under the impression that the VBA
library distributed with Office 2003 was the same as that with Office
XP -- am I mistaken?

Thanks,

Crazy

Error trying to run Excel 2003 Add-in in Excel XP
 

Hi Crazy Cat,

With the workbook in question active, run the problematic code

When the code errors, go to the VBE and select the project in the Project
Explorer Window

Hit the reset button and look at the Tools | References list

Look for any references marked as "MISSING".

Either uncheck the reference or, if the reference is needed, try the browse
button to locate the library,

---
Regards,
Norman



"Crazy Cat" wrote in message
ups.com...
Hi,

I wrote an Excel 2003 Add-in using VBA and distributed it to someone
using Excel XP (Excel 2003).

Whenever my client uses the app I am getting the following error when
the Mid function is encountered --

"Compile Error: Can't find project or library".

After I prepend the mid function with vba (so every instance of mid is
now vba.mid), the error goes away, but I'm wondering if all the
standard VBA functions will be affected in this manner and if there's
an easier resolution? Also I was under the impression that the VBA
library distributed with Office 2003 was the same as that with Office
XP -- am I mistaken?

Thanks,

Crazy

Error trying to run Excel 2003 Add-in in Excel XP
 

Norman Jones wrote:
Hi Crazy Cat,

With the workbook in question active, run the problematic code

When the code errors, go to the VBE and select the project in the Project
Explorer Window

Hit the reset button and look at the Tools | References list

Look for any references marked as "MISSING".

Either uncheck the reference or, if the reference is needed, try the browse
button to locate the library,


Thanks, Norman,

That did the trick.

Crazy

---
Regards,
Norman



"Crazy Cat" wrote in message
ups.com...
Hi,

I wrote an Excel 2003 Add-in using VBA and distributed it to someone
using Excel XP (Excel 2003).

Whenever my client uses the app I am getting the following error when
the Mid function is encountered --

"Compile Error: Can't find project or library".

After I prepend the mid function with vba (so every instance of mid is
now vba.mid), the error goes away, but I'm wondering if all the
standard VBA functions will be affected in this manner and if there's
an easier resolution? Also I was under the impression that the VBA
library distributed with Office 2003 was the same as that with Office
XP -- am I mistaken?

Thanks,

Crazy