VBA question

[nickra]

I have to learn and run some VBA to do a trading application in Excel.
1) Can I do this in Excel for Mac just as smoothly as Excel for
Windows. 2) Can I use Excel for Windows in my Mac (via Fusion or
Parallels) just as smoothly as Excel for Windows on a separate Windows
machine?

 

[Jim Gordon MVP]

Hi Nickra,

The short answers to your questions are "yes" and "yes."

VBA on the Mac is at version 5 in office 2004, but VBA is blasted to
smithereens in Office 2008. In Windows Office VBA is at version 6. You can
almost always find a version 5 work-around for VBA on the Mac, but the huge
bulk of VBA is the same as Windows.

Active-X is Open Source and does not work on the Mac.

I haven't tried Fusion, but I did buy Parallels and it works great for me in
Vista on Macs.

-Jim

I have to learn and run some VBA to do a trading application in Excel.
1) Can I do this in Excel for Mac just as smoothly as Excel for
Windows. 2) Can I use Excel for Windows in my Mac (via Fusion or
Parallels) just as smoothly as Excel for Windows on a separate Windows
machine?

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[JE McGimpsey]

I have to learn and run some VBA to do a trading application in Excel.
1) Can I do this in Excel for Mac just as smoothly as Excel for
Windows.

Just as smoothly - probably not. MacVBA is at version 5, while WinXL VBA
has been at VBA6+ since XL2000. ActiveX controls work only on the
Windows platform.

Most importantly, in terms of "smooth", the Mac VB Editor is a bare
bones version compared to WinXL - no watch window, no intellisense.

OTOH, I've always felt I have a better grasp of VBA and the XL object

2) Can I use Excel for Windows in my Mac (via Fusion or
Parallels) just as smoothly as Excel for Windows on a separate Windows
machine?

Yes. Performance depends on the machines, of course.