VBA Function not recognized in Excel

[SlicerRod]

I'm running Office 2003 SP3 on Vista using spreadsheets that I've created
under previous versions of Windows. I'm not a VBA programmer, but I've
managed to do enough coding through trial and error to be quite useful.
Whenever I enter a routine that has a function (ie, UCase$) in it, Excel
under Vista comes back with "Compile Error: Can't find project or library."

If I look through the object browser, UCase$ is there under "all libraries".
Do I have to declare that function somehow? Do I have to include the
library somehow? Again, all this code worked OK under XP.

Thanks in advance for your help.

 

[Ramesh, MS-MVP]

Make sure you have the required "References"? Click Tools => References

If not, you may try this question in microsoft.public.excel.programming newsgroup.

--
Regards,

Ramesh Srinivasan, Microsoft MVP [Windows Shell/User]
Windows® Troubleshooting http://www.winhelponline.com


I'm running Office 2003 SP3 on Vista using spreadsheets that I've created
under previous versions of Windows. I'm not a VBA programmer, but I've
managed to do enough coding through trial and error to be quite useful.
Whenever I enter a routine that has a function (ie, UCase$) in it, Excel
under Vista comes back with "Compile Error: Can't find project or library."

If I look through the object browser, UCase$ is there under "all libraries".
Do I have to declare that function somehow? Do I have to include the
library somehow? Again, all this code worked OK under XP.

Thanks in advance for your help.

 

[Andre Da Costa[ActiveWin]]

Microsoft Excel issues:
microsoft.public.excel

 

[SlicerRod]

I checked the Excel newsgroup and found the solution in the previous
response. Under references, there was a MISSING item that was checked. I
unchecked it and it started working. The missing item is no longer there,
but it had something to do with time. Why would that affect a character
function?

Thanks to both of you for your quick responses.