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
From the Excel for Mac forums in Microsoft’s Community website:
Is it possible to convert numbers into words in Excel 2011 for MAC?
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
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 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
Excel 2011 has huge improvements over previous versions. The ribbon replaces the floating toolbars & palettes. You can customize the Ribbon, or even disable it if you wish. Excel 2011’s includes automatic pivot table creation with a new PivotTable Builder to ease building and modification of pivot tables, and pivot table report designs, layouts, and styles. VBA is back so if you were stuck in Excel 2004, you can finally retire Office 2004. Sharing and . . .
Continue Reading: Excel