14 thoughts on “Excel 2011 on the Mac”

1. Seeing this makes me really happy I only have to support Windows (XP and Win7) and variants of Office (03, 07, 10).

   Why not just run your code under bootcamp?

   Also, do you have to put the procedures with apple script into separate modules?

2. Hi David

   I run Fusion(VmWare) on the Mac and have always Windows 7 open (with 8 gb of ram)
   In lion you only have to swipe with 3 fingers on the trackpad to go to Windows or back to the Mac.
   This is working great for testing with a shared folder on the Mac that all my virtual machines can use.

   You not have to use a seperate module, the script is a normal string that you can run with the MacScript VBA function.

   But you are correct there is a lot of work to do in Office for the Mac.

3. Ron –

   I’ve tried to move a lot of macros into the Mac environment, and it’s never easy. The most usual problem is having to preface all vba functions with “VBA.” as in Right$() to VBA.Right$(). If I don’t (and I never find them all) I get hit with “Can’t find library or project.” complaint.

   …mrt

4. Thanks Michael

   I will check that out and add it to the page next week

   This weekend I will publish some Excel workbooks Merge code for the Mac on the page.

5. Hi Ron,

   The biggest ouch for me is the lack of keyboard shortcut for “Paste Special”.
   I’m a both-world Excel user, so I often press “alt+e+s+v” on my mac. I wish this could be solved :)

6. Ron,

   I’m not sure if you can help with this but I will give it a shot. I use the SMF Add-in at work on a PC but I tried to install it on my Mac at home and I am getting messages about missing Microsoft Libraries that the program can’t find. It appears that the missing libraries are:

   Microsoft Internet Controls
   Microsoft XML v 3.0
   Microsoft HTML Object Library

   The add-in is available for frree here, http://finance.dir.groups.yahoo.com/group/smf_addin/

   Can you think of a work around for this?

   Thanks,

   Ron

7. Andrei –

   My solution for aligning keyboard equivalents on the Mac to the PC is Quickeys, from Startly.

   http://startly.com/products/quickeys/mac/4/

   …mrt

8. Hi Ron,

   Might be good to include how to use conditional compiler constants too:

   #If VBA7 Then
       ‘Office 2010 or up
      #If Win32 Or Win64 Then
           ‘Windows
      #Else
           ‘Mac
      #End If
   #Else
       ‘Office 97 to 2007
      #If Win32 Then
           ‘Windows
      #Else
           ‘Mac
      #End If
   #End If

9. Good suggestion JK

   Will test and add it this week this week, and also code examples
   to select a folder and files

10. I have an iMac with Office 2008, and a MacBook Pro with Office 2011. On both I run Parallels 6 with Windows 7 Ultimate, and Office 2010 Professional.

    I work as an Excel Consultant and I can tell you that I get many more Excel for Mac projects this year than last year. Significantly more. It seems that Excel on the Mac has taken off as of late.

    I also have Excel programmers that program for the Mac, in Windows.

    Once you get used to the Mac interface and Excel specifically, the Mac is GREAT. It does not crash, there is less risk of virus attacks, and they start faster than my Dells. Plus, with Parallels they are two computers in one.

    I love Excel 2011 on the Mac. You should give it a try.

11. I love the Mac but there is a lot of work to do in Office 2011 Chris.
    And that is the best version that is made.

    I will never buy a standalone Windows machine anymore.

12. hey Ron,

    did you managed to get SMF Addin to work with MAC?

13. I add some new code to merge files on my Mac page
    If you are on a Mac and have time please test it for me

14. Ron – can you share any edits to the code for the SMF add-in to work on Mac? I’m having the same issues.

Posting code? Use <pre> tags for VBA and <code> tags for inline.