Right$ function?

Hello,

I wrote a VBA program which works fine on my machine, but chokes on
someone else's.

The user selects a piece of text and the program uses the text to query
some XML data.

The program trims off the control characters %%U which causes the text
to be underlined in ACAD but is not relevent to the data.

His machine says it doesnt understand this most basic BASIC function Right$.
Where did it go?

Why does it work on my machine but not someone else's?


Is there some way to make an installation program for a VBA project? Such
that any missing DLL's and/or VBA commands that the program uses will be
supplied to the user's machine?

thanks for any assistance

jm

 

Remove the $ sign from Right - its been RIGHT for a long time now. Best
guess is your machine probably has an older vb dll on it that understands
the Right$ command while the other user's doesn't.

-- Mike
___________________________
Mike Tuersley
CADalyst's CAD Clinic
Rand IMAGINiT Technologies
___________________________
the trick is to realize that there is no spoon...

 

Vba can bomb on standard functions if you have a missing reference. The user probably doesn't have the xml support, etc.

 

thanks ed

you were correct. i used a VB6 install of another program which uses the same dll

now this other machine understands simple VBA functions as well as the missing big stuff

thanks again

jm
Vba can bomb on standard functions if you have a missing reference. The user probably doesn't have the xml support, etc.