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 example, in 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 . . .

Continue Reading: AppleScriptTask in Office 2016 for the Mac

Use VBA to convert numbers to words in Excel

From the Excel for Mac forums in Microsoft’s Community website:

Is it possible to convert numbers into words in Excel 2011 for MAC?

For example,

USD19,324.50 -> US Dollar Nineteen Thousand Three Hundred and Twenty Four Dollar and Fifty Cents

Fellow MVP Bob Greenblatt directed the poster to Microsoft’s instructions for How to convert a numeric value into English words in Excel. Below are the equivalent steps for Excel for Mac. Note: these instructions will . . .

Continue Reading: Use VBA to convert numbers to words in Excel

Use AppleScript or VBA to paste unformatted text in Word for Mac

Working with formatted text copied from a stylized source such as a web page can make editing in Word for Mac laborious. For someone who does it frequently, selecting Edit > Paste Special, choosing Unformatted Text and clicking the OK button is a lengthy mundane process. This command has no quick keyboard shortcut and Apple’s feature to assign a keyboard shortcut won’t work because the command isn’t in a menu.

Fellow MVP Rich Michaels recently . . .

Continue Reading: Use AppleScript or VBA to paste unformatted text in Word for Mac

Microsoft releases Office for Mac 2011 14.3.2 Update

Microsoft has released the Microsoft Office for Mac 2011 14.3.2 Update. (113 MB) Installation requires first installing the 14.3.1 update. According to the update’s description it addresses one security issue and includes multiple bug fixes.

The update addresses a vulnerability in Microsoft Outlook for Mac that could allow Internet-based images to be downloaded without the customer’s consent. This would allow the site to know the message has been received and viewed.

. . .

Continue Reading: Microsoft releases Office for Mac 2011 14.3.2 Update