Vista - VBA Function not recognized in Excel

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.

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


"SlicerRod" <nospam@xxxxxx> wrote in message news:C6BABDA9-B4CB-463F-AAA4-E37BB48B7B1F@xxxxxx
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.

Microsoft Excel issues:
microsoft.public.excel
--
Andre
Blog: http://adacosta.spaces.live.com
My Vista Quickstart Guide:
http://adacosta.spaces.live.com/blog...3DB!9709.entry
"SlicerRod" <nospam@xxxxxx> wrote in message
news:C6BABDA9-B4CB-463F-AAA4-E37BB48B7B1F@xxxxxx

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.

"Andre Da Costa[ActiveWin]" <andred25@xxxxxx> wrote in message
news:#EnbXLtTIHA.5016@xxxxxx