Excel AppleScript Dictionary

[Tom_Keene]

I started converting my Personal Macro Workbook to AppleScript and ran into a problem with the Dictionary.

There seems to be no AppleScript term for the VBA WorksheetFunction object. What have other people done about the problem?

Cheers,
Tom

 

[JE McGimpsey]

I started converting my Personal Macro Workbook to AppleScript and ran into a
problem with the Dictionary.

There seems to be no AppleScript term for the VBA WorksheetFunction object.
What have other people done about the problem?

Access to built-in functions is not implemented in Applescript,
apparently due to conflicts in how XL and AS handle data types.

The way to implement Worksheet Functions in AS is to write the function
with the appropriate parameters to a worksheet (which can be generated
temporarily for this purpose and hidden), let XL calculate the result
and pass it back (i.e., as the cell value) back to the script, then
clear the cell.

It's clunky to implement, but as with VBA, it's sometimes actually
faster to run than using the VBA WorkSheetFunction object.