C
Crazy Cat
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
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