Visual Basic Support in Mac 2016

Please keep in mind that I do not work for nor do I speak for Microsoft. Nor did I sell you the software, so I can't give you your money back.

Office 2011 for Mac has a reasonably complete Visual Basic Editor along with ODBC data analysis tools that actually work. Perhaps you can exchange 2016 for 2011.

I have stated that I think Office 2016 is not only the worst version of Microsoft Office that has ever been released, I think it is the worst commercial software I have ever used. 

That said, Microsoft seems to be trying to address Office 2016 shortcomings one feature at a time. Earlier in this Q&A I noted that the Visual Basic Editor wasn't working at all in El Capitan. Now the totally worthless piece of **** editor is working in El Capitan, but it is still a sorry thing to see.

 I do not work for Microsoft.   If I did.  I would feel that every update to Windows core PC products (Windows, Office, etc).  has considerably gotten worse in a shockingly downward trajectory.

I often find myself going to the library to use the Windows 2003 PC with Excel 2003.   

Note:  I have 3 macs, one with OFFICE 2011 (I think?),  the new 2016 OS X version,  and I have a personal windows 10 laptop with Office on that.

I will say this.    I couldn't agree more with your comments.   Excel is supposed to be a very useful program in comparison to say, 80's era HP 12C or TI-84 Calculators.    I find it the opposite.   I end up using the brick like 1984 style HP12c vs. Excel anyway for the most simple tasks.  

That's telling.    No doubt Excel is a powerful calculator.  I was reading a story about MIT's early 60's Fortran computer lab.   And the mathematics crunched through that beast.     Yes.   Excel has enormously more power than that beast 1960's era MIT super computer.

Fair.    It has some impressive power upgrade to 1980s era brick style calculators.    HP12C  HP10BII or similar types of calculators *(without the ease of use or quickness or reliability).

This leads me to my final point.     I can't tell if the Windows 10 version of Excel 2016 is significantly worse than the OS X 2016 version of excel  --  which is in general the worst software I've ever used for the mac.     In fact, the bugginess of the app itself is so incredible.  I can't tell you how many times I consistently crash a spreadsheet by clicking on a formula tab by accident and then --- CRASH!!!!

I can't tell you how USELESS EVERY VBA code ever written is within the framework of excel on all the versions I've used.  

I can't tell you how UGLY and completely uninspiring the graphics of the charts are.   How incredibly unworkable the editing of those graphs are..

I can't explain how MEANINGLESS and USELESS VBA code is in any respect to the new Excel.    FORGET THE VBA code if you're using anything beyond 2009's version of OFFICE.  

It won't work.   and you will crash and reboot constantly or just waste your time.  

The idea behind excel was it was supposed to be powerful, quick, reliable, and useful. 

It is SLOW!    VERY SLOW!    Processor speed aside.   This Application on both operating systems are POWER HUNGRY bug ridden monsters.    You need a literally super computer (a cluster array of servers in the basement) to use this app without banging your head on the wall.

AT THE VERY SAME TIME?    

I USE IT A LOT!   UNHAPPILY!

I have not switched to Matlab, Mathematica, R, or Python entirely.    

But I am planning to one day kibosh Excel altogether and go to R and Python.  

This product is the worst updated product in all of Microsoft's catalogue.    

I think the programmers who made these apps are smoking FLAKKA and literally inhaling nitrous while they code this like -- I imagine the worst coders of the company in the basement of the corporate offices of MSFT --- with one red stapler..   so uninspired and unhappy with their lives --  they take their frustrations out on the software itself..  because it's bludgeoned to death by mediocrity!

I need to get on EBAY now.   and buy myself a WINDOW'S 2003 computer with Excel 2003 on it.    because it's the last time this app was useable to any reliable degree.

Very soon Microsoft is going to switch Office for Mac from 32-bit to 64-bit. This should have been done more than a decade ago IMHO. Whether or not they will do the right thing and go multi-core multi-threaded at the same time remains to be seen. In any event, there should be some performance improvement in Office for Mac when they make the switch.

Thanks for the info Jim.  This is not surprising.  The VBA editor currently is obviously a placeholder lacking any decent level of functionality.  It is also easy for MS to see a slow but continuing enterprise migration to a mixed OS world.  This is very obvious in my work environment at a large multinational.  Macs are very common now in many areas.

I continue to find the combo of Parallels and Windows Office to be a highly acceptable solution albeit with the additional software cost of purchasing Parallels.  I was surprised to find the speed to be comparable or better than running Windows/VBA on a high end PC.

Microsoft is now working on building a new VB Editor to replace the defective piece of garbage they supplied with Office 2016. ETA has not been announced.