Menu

How to evaluate string form of numeric expression in VBA?

Search this Thread

Prev

Previous Post

Next Post

Next

#7

Report Post

Posted to microsoft.public.excel.programming

Dave Peterson Dave Peterson is offline

Dave Peterson is offline

external usenet poster

Posts: 35,218

Default

How to evaluate string form of numeric expression in VBA?

I don't know anything that would work the way you want.

wrote:

On Dec 31, 6:38 am, Dave Peterson wrote:
If the string you're evaluating is simple, maybe you could parse it to its
component parts and do the arithmetic yourself using VBA's functions.
But parsing a generic string/formula sounds pretty daunting to me.

Parse __and__ generate Intel-compatible assembly code!! I believe
that would be the only way of ensuring exactly the same results that
VBA produces, including side-effects of using the FPU registers for
intermediate results. (Unless, of course, you are also proposing that
I emulate the 80-bit arithmetic as well <wink.)

And yes, I would need a generic expression parser/code-generator
because the expressions are complex and unpredictable.

Enough said! I take your response to mean: there is no such thing as
"someFunction" in VBA that will evaluate a numeric expression in
string form exactly as if I had entered it into VBA directly.

Not the answer I wanted. But thanks for clearing that up for me.

--

Dave Peterson

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
evaluate a concatenate expression	Russell.Ivory[_2_]	Excel Worksheet Functions	3	November 4th 09 05:52 PM
evaluate a year expression	Clint Eastwood[_2_]	Excel Programming	2	November 8th 07 04:50 PM
Evaluate Custom Expression	Peter	Excel Programming	7	April 3rd 06 01:18 PM
Giving the String expression for Numeric Values....	Arijit Chatterjee	Excel Programming	2	November 19th 03 10:57 AM
How to evaluate a text expression as formula ?	Krzysztof Klimczak	Excel Programming	0	August 29th 03 04:31 PM

All times are GMT +1. The time now is 10:16 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement