Category Archives: Mac

Excel and PowerPoint 2016 for Mac gripes

Posted on May 4, 2018 by Patrick O'Beirne, Excel/VBA developer

I’ve been trying to maintain compatibility between Mac and Windows versions of Excel/VBA apps for a while now, and it’s a pain. These notes refer to versions 16.14 of both Excel and Powerpoint. Here are some of my recent threads … Continue reading →

Posted in Excel/VBA, Mac, powerpoint, Uncategorized | 6 Comments

Mac Excel vs PC Excel

Posted on Oct 28, 2011 by Patrick O'Beirne, Excel/VBA developer

Here’s a summary of my work on a Mac with Excel 2011, trying to make an existing Excel 2007 addin compatible with it. There are quite a few incompatibilities. The main ones are: 1) No RibbonX menu, you have to … Continue reading →

Posted in Excel/VBA, Mac | Leave a comment

More differences between Excel for Windows and Excel 2011 for Mac, mainly VBA

Posted on Oct 24, 2011 by Patrick O'Beirne, Excel/VBA developer

For the official MS list of differences see http://mac2.microsoft.com/vb/1033/Excel/html/xlmscChangesBetweenExcel2010and2011.htm “The following is a summary of the diffferences in the Microsoft Excel 2011 for Macintosh visual basic object model as compared to Microsoft Excel 2010.” Here’s my own list, the last … Continue reading →

Posted in Excel/VBA, Mac | Leave a comment

List of Mac Excel 2011 differences from Excel 2007

Posted on Oct 21, 2011 by Patrick O'Beirne, Excel/VBA developer

1) DIR() returns error rather than null string, so trap it 2) rg.Find Searchformat named argument not found Same for ReplaceFormat 3) rg.Autofilter Help says “If you omit all the arguments, this method simply toggles the display of the AutoFilter … Continue reading →

Posted in Mac, Risk | 1 Comment