KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
4D Summit: Manipulating MS Excel from 4D v11 SQL
PRODUCT: 4D | VERSION: 11.3 | PLATFORM: Mac & Win
Published On: October 7, 2008
This technical article is currently restricted to 4D Summit attendees and Partners Only. Login with your Customer account to have full access to this article!!!
Log In

AppleScript, the built-in scripting language of Apple, enables cross application communication on the Mac OS X platform. You can tell other applications to open a specific document, perform a particular task and return certain data. 4D itself is not an AppleScript scriptable application; still, thanks to Web Services (SOAP), you can publish your project methods to be called from other applications via AppleScript. For example you can setup a call to a 4D method as an e-Mail rule, an iCal event, or even a folder action. You can also run AppleScript with 4D thanks to the 4D command LAUNCH EXTERNAL PROCESS and the BSD command osascript. In this session we will investigate how AppleScript can be used in an effective manner to let 4D interact with other Applications such as MS Excel. We will also see how the method editor can be customized to incorporate AppleScript codes.