Using String to do calculations

[hsviljoen]

Hi there,
I have formulas stored in a string var. I want to do a calculation with this var.

E.g. Value = 10/ formulaSTR

Is this possible - I tried the above but I get a "TYPE" error - due to the string.....

The string contains the following (14*.014)/(22.73*0.1243))

Help would be much appreciated.

 

[bboffin]

Take a look at the Eval function. This should do the trick.

 

[johnwm]

There is a concise example in strongm's post in thread222-623714

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'