Using formulas inside AppleScript

[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 + &quot&quot)

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.

 

[Andrey_Kazak]

For those who is interested:

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

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

 

[Andrey_Kazak]

For those who is interested:

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

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