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

Merge Add-in for Excel 2011 for the Mac

Briefly! RDBMerge is a user friendly way to Merge Data from Multiple Excel workbooks into a Summary Workbook. By Ron de Bruin Excel Automation

Install the RDBMerge utility Download the file. Copy RDBMergeMac.xlam to the folder you want on your Mac. Tip: Use one folder for all your add-ins (easy to backup your add-ins this way) Start Excel and open a workbook.

Excel 2011

Click Tools, click Add-Ins, use “Select” to go to and select . . .

Continue Reading: Merge Add-in for Excel 2011 for the Mac

Use Outlook with Excel add-on RDBMailMac to email Workbooks

Ron de Bruin, Office MVP-Excel has provided a Mac version, “RDBMailMac” of a popular Excel/Outlook add-on for Windows “RDBMail or SendMail add-in”. RDBMailMac puts emailing of Excel sheets, data, and workbooks where you want it and when you want it as Workbook.

Download links

Windows version: http://www.rondebruin.nl/mail/add-in.htm

Mac version: http://www.rondebruin.nl/mail/helprdbmailmac.htm

. . .

Continue Reading: Use Outlook with Excel add-on RDBMailMac to email Workbooks

Track New Year resolutions with Excel

For anyone who makes lots of New Year resolutions or needs to track progress with other long term goals, Excel can make the magic happen. Fellow MVP Purna Duggirala posted an Excel spreadsheet template that takes advantage of conditional formatting and check-boxes to create a list of goals and track progress as they’re completed. Check completed items and watch as the progress thermometer moves toward 100%.

The template was designed to track 101 things . . .

Continue Reading: Track New Year resolutions with Excel

Convert old Excel (.xls) files to standard (.xlsx) files

Mac MVP James Gordon has posted directions on how to convert old Excel (.xls) files to standard (.xlsx) files using Automator.

What does this converter do? You choose one (.xls) file, several (.xls) files, or an entire folder filled with (.xls) files and the converter will save a copy of each Excel file in standard open XML file format, better known as the “new” (actually more than 5 years old now) Excel (.xlsx) format. This . . .

Continue Reading: Convert old Excel (.xls) files to standard (.xlsx) files

Access buried features in Excel with a free toolbar

Fellow MVP Jim Gordon, co-author of the soon to be released book Office 2011 for Mac All-in-One For Dummies, has posted a free toolbar for Excel 2011 for Mac. The toolbar contains more than 30 generally convenient commands, form controls for worksheets and dialog sheets, VBA commands and some not so convenient tools.

Download the toolbar from his website and open the Excel document. The new toolbar will appear above the new Excel window but . . .

Continue Reading: Access buried features in Excel with a free toolbar

Excel 2011 defaults to 1900 date system

Effective with Office 2011, Excel’s preferences will now default to using the 1900 date system instead of the 1904 date system. From Excel 2008 to 2011, this change is as simple as unchecking one preference selection, however, all new workbooks will now use the different date system by default.

What is significant about 1900 and 1904?

That could be a chicken-and-egg discussion. Excel for Mac uses the 1904 date system and Excel for Windows uses . . .

Continue Reading: Excel 2011 defaults to 1900 date system