 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / October 2007VBA question
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? 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 Quoting from "nickra" <nickravo@gmail.com>, in article 1192674603.426352.10960@e9g2000prf.googlegroups.com, on [DATE: > 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?  SignatureJim Gordon Mac MVP MVPs are not Microsoft Employees MVP info http://mvp.support.microsoft.com/ > 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 model since I didn't have all those crutches...<g> > 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.