Calling Applescript from Excel

[gimme_this_gimme_that]

Now that M$ is mulling over a conversion from VBA to Applescript ...

Is there a way to call Applescript from VBA?

That would allow developers to make controls (such as dropdowns and
buttons) whose triggers evoke Applescript instead of VBA.

Something like a VBA editor for Applescript would be great.

Is there a way in Applescript to associate a button in Excel with a
Applescript event?

Thanks.

 

[JE McGimpsey]

Now that M$ is mulling over a conversion from VBA to Applescript ...

Nope, not mulling. They're dropping VBA from Office2008. The OLE hooks
will still allow control of XL via AppleScript.

Is there a way to call Applescript from VBA?

Yes, use the MacScript() method.

That would allow developers to make controls (such as dropdowns and
buttons) whose triggers evoke Applescript instead of VBA.

This has been available since at least MacOffice98.

Something like a VBA editor for Applescript would be great.

You can use the basic Script Editor.app, of course, or the XCode IDE
(including AppleScript Studio). And there are intermediate packages:
Script Debugger, Smile, etc.

Is there a way in Applescript to associate a button in Excel with a
Applescript event?

Currently you can use Applescript to modify the XL U/I, so you can use
Applescript to set the OnAction property of a button.

That won't be available in Office2008, since the OnAction property calls
a VBA routine.

However, you can already use the system to call applescript routines
now, by putting the applescripts in the script menu (the system one for
now, we'll see whether Office apps get their own script menus).