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
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.
Click Tools, click Add-Ins, use “Select” to go to and select . . .
Continue Reading: Merge Add-in for Excel 2011 for the Mac
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.
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
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
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
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
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