
Microsoft introduced Visual Basic for Applications a long time ago, with the main purpose of using it for automation of tssks within Office applications.Ĭlearly you know how to access the developer tools within the Outlook app, and you seem to be comfortable with the Visual Basic programming language. Let me know if you have any recent experience with Applescript and Keynote.At this point I'm questioning your reasons for wanting to use AppleScript for Microsoft Office automation. I am not giving up, and will look for a solution. Now, I am not saying that all esoteric features should be supported in a scripting language, but I am struggling to get the most obvious and basic one that anyone wants to use a Keynote script for: batch conversion of PowerPoint files into Keynote. Old tutorials online show functionality that has been removed in later versions of Keynote. As Apple put development of Mac OS on the back burner and gave priority to its iOS devices, the functional power of Applescript has been watered down. The second problem is the what Applescript can actually do.

Writing macro scripts will never be something that the average Apple user will do, so you might as well stick to a programming language that an engineer can work with. When I look at example Applescript code, it looks very easy to adjust and re-use, but it is an incredibly pain to get it actually working and iron out the last bugs. It is incredibly hard to use it to program computers. And here is a problem: human language is ambiguous. It has been around for a very long time, but it is falling short.Īt first sight, the language looks very friendly, almost human-like. Applescript is a language that aims to automate pretty much everything you can do in Mac OS.


Things in the Microsoft Office ecosystem run smoothly ("VBA"), for Mac, a lot less so. I am dusting of my coding skills that were pretty much put on hold in the early 1990s and have started to program macros to automate the mechanics of the template store: creating individual slides and thumbnails for PowerPoint and Keynote in different aspect ratios of these design.
