PDA

View Full Version : VBA compatibility Excel 2010 / 2011



henpat
12-13-2010, 01:36 PM
Hi all
I have a VBA code in Excel 2007, but now we will migrate to Excel 2010 and Mac users to Excel 2011.
There is a way to migrate the original version from 2007 to 2010 and 2011?
Or I need to create two different versions? one for PC and other for MAC?

Note: I tried to open my file xls in Excel for mac 2011, it request to enable macros, I press "Enable Macros" but nothing happens, when I open my forms some controls don't exist any more.

Thanks for your help and advices.

Kind regards.

mikerickson
12-13-2010, 01:52 PM
Mac doesn't support ActiveX controls, so if you have any of those then multiple versions would be needed.

If you are working in a mixed platform environment, it might be best to do all your designing in Excel 2004 (or 2011) , so that everything will be compatible.

dub
12-20-2010, 11:39 AM
I have Microsoft office for Mac 2008, does this version have VBA, also does it have an equation editor?
thanks

mikerickson
12-20-2010, 01:03 PM
Excel 2008 does not support VBA.
Equation Editor? I don't know, but it does the the Insert Function feature.

dub
12-20-2010, 02:35 PM
Does Office for mac 2011 (home/student version) support VBA? I am thinking of getting it, but need VBA for school and that would be the main reason I would buy it, are there any expected problems with this upgrade (will all my files from 2008 for mac open up correctly? and will VBA code I work on at school on the dell computer (Office 2010 maybe?) work on mac 2011 if it does have VBA)? Do you know how many computers it can be installed on?
Thanks!
:xnoel:

mikerickson
12-20-2010, 04:36 PM
Yes, Excel 2011 has VBA (Yes, get the upgrades). (If look at the VBA help thread in this forum.)

Yes, Excel 2011 VBA will run on Excel 2010. The reverse???, not nessesarily, there are some features that are avaliable to Windows that aren't to Mac. (ActiveX controls and the scripting dictionary are two). BUT...If you are only using VBA as a platform for an introductory programming course, its unlikely that you will run into those differences. The class will be about flow charts, not how to use controls.
Ask your professor if you'll need access to Windows VBA's "regular expression" abilities. Mac doesn't have them.
Worst case, get Paralells (or similar), install Windows on your Mac, and run 2010 on that platform.

If I remember my 2011 license correctly, you can install it on only one machine. You can do it three times, but only on one machine. Contact MS or your software dealer for details about the licensing agreement.

dub
12-21-2010, 12:24 PM
Thanks for the info

ajn946946
01-23-2011, 07:56 PM
This clears a few things up thanks.