EVALUATE function 1

[electricpete]

This is a spinoff question from thread770-113109

What is the evaluate function? It is not described in help. Can you provide an example of it's useage. I could not get it to work no matter what kind of datatype I fed it.

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

 

[IRstuff]

http://support.microsoft.com/?scid=.../servicedesks/bin/kbsearch.asp?article=131384

TTFN

 

[CajunCenturion]

The Evaluate function allows you do dynamically build a string, which is a mathematical forumla. The Evaluation function then allows you to run that function so to speak, something like the following:

dim TheFormula as String

TheFormula = "SQR(x^2+y^2)"
Result = Evaluate(TheFormula)

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein