Using formulas inside AppleScript

A

Andrey_Kazak

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Greetings!

I need to evaluate formula inside my applescript. In the old days of VBA I've done it with the following command:

CInt(Evaluate("=LEN(" + Address + ")"))

But I haven't managed to find something similar in the AppleScript dictionary for Excel 2008.

Could you help me to overcome the problem please?

P. S. I appreciate you prompt and clear reply.
 
A

Andrey_Kazak

For those who is interested:

round (evaluate name ("=LEN(" & Address & ")"))

P. S. I found "evaluate name" to be slightly undocumented.
 
A

Andrey_Kazak

For those who is interested:

round (evaluate name ("=LEN(" & Address & ")"))

P. S. I found "evaluate name" to be slightly undocumented.
 
Top