AppleScriptTask in Office 2016 for the Mac

AppleScriptTask in Office 2016 for the Mac

In Office 2011 for the Mac there are many problems with the built-in VBA commands. For Example Dir, Kill, GetOpenFilename, GetSaveAsFileName and many others. For examplein Office 2011 file names in VBA are limited to a maximum of 32 characters including the extension. If the file name is longer the code fails.

VBA developers responded by using AppleScript in many situations to work around the problems. They also used AppleScript to do things that are not possible with VBA code; for example to email using VBA code, Excel 2011 and Outlook 2011.

In Office 2016, we need to use a new method and a new approach explained below.

Continue reading on Ron de Bruin’s Excel Automation site.

Share this:
  • Twitter
  • Facebook
  • del.icio.us
  • Digg
  • StumbleUpon
  • Google Bookmarks
  • PDF
  • Print

1 comment to AppleScriptTask in Office 2016 for the Mac