VB Evaluation Function

Hello Guys;


I was wondering if anyone has seen or written a vb math evaluation function. I'm hoping I dont need to buy it from a 3rd party guy.


The function that I require goes like this :


Dim x, y

x = 1

y = 2


z = " x + y "


I need a function that will evaluate the above expression. Please do reply, I need to complete my project soon. As for now I have managed to use the SQL statement to evalute string expression :


eg. "Select " & z & " as z form table1"


regards. Help URGENT!!!!!!!!!!!!!!!!

Hi


Take a look at http://www.softcircuits.com. They have a code example for processing evaluations. It shows how to do simple maths, and can be expanded to do pretty much anything (if you understand how it works)


Regards


Chris Eastwood