Windows Vista 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]

Re: VBA Function not recognized in Excel

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@comcast.net> wrote in message news:C6BABDA9-B4CB-463F-AAA4-E37BB48B7B1F@microsoft.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]]

Re: VBA Function not recognized in Excel

Microsoft Excel issues:
microsoft.public.excel
--
Andre
Blog: http://adacosta.spaces.live.com
My Vista Quickstart Guide:
http://adacosta.spaces.live.com/blog/cns!E8E5CC039D51E3DB!9709.entry
"SlicerRod" <nospam@comcast.net> wrote in message
news:C6BABDA9-B4CB-463F-AAA4-E37BB48B7B1F@microsoft.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.

 

[SlicerRod]

Re: VBA Function not recognized in Excel

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@hotmail.com> wrote in message
news:#EnbXLtTIHA.5016@TK2MSFTNGP06.phx.gbl...
> Microsoft Excel issues:
> microsoft.public.excel
> --
> Andre
> Blog: http://adacosta.spaces.live.com
> My Vista Quickstart Guide:
> http://adacosta.spaces.live.com/blog/cns!E8E5CC039D51E3DB!9709.entry
> "SlicerRod" <nospam@comcast.net> wrote in message
> news:C6BABDA9-B4CB-463F-AAA4-E37BB48B7B1F@microsoft.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.
>
>