| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving Excel 2003 Workbook in Excel 07 - Error Msg on Script obj | Excel Discussion (Misc queries) | |||
| Strange 'protected cell' error affecting Excel 2003 but not Excel 2000? | Excel Discussion (Misc queries) | |||
| Excel 2003 file opend in Excel 2000 - Compile error in hidden modu | Excel Programming | |||
| Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
Threaded Mode
