Close

January 14, 2016

The VBA Editor inside Word 2016 for Macs is *useless*!

I’m trying to port my Word Toolbox across to the Mac, using Word 2016, but failing at almost every step.

According to what I’ve read online, this version of the VBA Developer engine has (apparently) been gutted and re-created from scratch, but in doing so Microsoft have left out *loads* of features:

  • The basic menus and buttons that are in Office 2011 (based on screenshots I’ve seen) haven’t made it through to this version.
  • I can’t edit any user forms, but I can, for some reason, insert a module.
  • The ENIVRON variable, which gives me (on my PC) some 47 different variables that I can investigate .. is lowered to 15 on a Mac. Some I expect not to be available because that’s not how Macs work, but others really should be there.
  • Simple code that works perfectly on Windows, crashes on the Mac. E.g. looking for any Chart objects.
  • I can’t seem to close a form without causing a crash.
  • Others that I can’t remember as I’m trying to blank them from my mind …
  • I’ve read that this is just an “initial version” and a better version of the Developer mode will follow, but as a first version it’s a waste of space. Even one of our Mac-loving website developers took one look at the VBA editor and noticed how much was missing compared to what he remembered being in Office 2011’s VBA editor.

There’s not a great deal of help online, but there’s more than a fair few complaints aimed at Microsoft for what they’ve released. So, has anyone else tried their hand at either porting a PC Word add-in across to a Mac using Word 2016?

  • If so, did it work?
  • How easy was it to tweak the code?
  • How many #If Mac Then … #End If commands did you have to put in your code?

I’ll keep at it, but losing the will to contemplate having to rewrite 100% working Windows VBA code just to please the nuances of a half-baked attempt of a Mac version 🙁

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: