Left$ must proceed with VBA. in Office 2000

[keksforscher]

Hello,

I have a vba-makro which uses left$, right$ and trim$. It runs fine
under Office 2003/XP/2000. On another PC with Office 2000 it produces
an error. If I write VBA.Left$ instead of only Left$ it runs on that
PC without problem too. I don't know why. Could anybody explain that?

Thanks

Stefan

 

[Cindy M.]

Hi Keksforscher,

I have a vba-makro which uses left$, right$ and trim$. It runs fine
under Office 2003/XP/2000. On another PC with Office 2000 it produces
an error. If I write VBA.Left$ instead of only Left$ it runs on that
PC without problem too. I don't know why. Could anybody explain that?

This usually indicates either a missing reference (Tools/References) or
a problem with the machine's configuration. If you open the VBA project
on the problem machine, go into the VB Editor, then Tools/References do
you see anything listed as "Missing"?

And which application is this macro for?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail