We have had a number of inquiries about Excel, the Rental Workbook, and whether it will work with Macs.
We recently discovered that the VBA functionality has been included in Excel for Mac 2011. This is an important feature as it supports all of the Excel application objects and methods of Excel 2010 for Windows. This makes this version for Mac a more viable option and we are investigating the Rental Workbook to see how it works with the Mac. This is very good news, as previous Office for Mac versions have not been able to run the Rental Workbook.
We did discover though, that external objects referenced within VBA projects are limited within Excel for Mac 2011 in cases where the Windows based objects are not available on Mac OS X. This means that when Upgrading or Renewing, Mac users will need to refer to us for processing because the Renewal and Upgrade files are referencing the ‘External Object’ which is the users own Rental Workbook file. We can run this process for users manually, returning the Renewed or Upgraded file back to the client without a problem (on recent tests at least).
At this time, we do not have a separate version of the Rental Workbook that will run on a Mac that does not have a PC emulator.
In addition, the ‘new’ Office 2008 for Macs will not support the programming for VBA that we use to create the Rental Workbook (the reason you choose to Enable Macros when opening the Rental Workbook).
We recently searched for help from Microsoft on this issue, and found the following quote:
“Why remove VBA for Office 2008? While Office 2008 was built to be a universal application because Apple moved to Intel processors, the Macintosh VBA compiler was originally designed for a much earlier PowerPC-based Macintosh and will not work, without significant modifications, on the Intel-based Macintosh. VBA macro code is compiled at runtime, and the compiler code, VB editor code, and VB forms code could not be converted for the Intel-based Macintosh without extensive programming work that would have significantly delayed the universal version of Office 2008.
The Microsoft Office for Windows version of VBA can’t be directly used for Office 2008 because it depends on execution of Windows machine assembly, which isn’t compatible with the Mac OS”
“Furthermore, macros found in the new “m” file formats of 2007 Office suite for Windows (.docm, .xlsm, .pptm) will not run on and can’t be converted for Office 2004 (or Office 2008, or any version of Office for Mac”
So we don’t envisage a Mac version of the Rental Workbook for some time unfortunately.
We’ll keep you posted on any updates.