Sol Apache said:
Will AppleScript be accessible via a menu. Currently my Tools>macros menu
command has a submenu displaying ³Visual Basic editor ² and ³REALBasic
editor². Is there any way now that I can add ³AppleScript² to this menu, and
are there any samples of internal use of AppleScript in Word, using the
document object models.
Don't know for sure whether there will be an AppleScript menu in XL08 or
not, though I'd very much expect so.
You CAN add AppleScript, along with the appropriate user forms and code
to implement the menu item to the Tools/Macros menu using VBA (post back
if you want instructions), but I use the system AppleScript menu. If you
don't have it enabled already, run the
HD:Applications:AppleScript:AppleScript Utility
application and click "Show scripts menu in menu bar" checkbox. You'll
see a script/scroll icon appear in the menu bar.
From than menu, choose "Open Scripts Folder/Open User Scripts Folder".
Create a folder named "Microsoft Excel" within the "Applications" folder
inside the Scripts folder. Doing that ensures that XL scripts in that
folder only appear when XL is the active application.
Paul Berkowitz has written a guide called "Moving from Microsoft Office
VBA to AppleScript" for MacTech magazine. A draft is being distributed
at MacWorld, but it will be posted on the MacTech site soon, and, I'm
told, published in the magazine in a couple of months. It's about 140
pages of excellent info.
You can also get Microsoft's AppleScript Reference guides for XL, Word
and PPT at
http://microsoft.com/mac/resources/resources.aspx?pid=asforoffice