Results 1 to 5 of 5
  1. #1


    Member Since
    Jan 12, 2010
    Posts
    12
    Question Visual Basic - Microsoft Excel 2008 For Mac - Help!
    I need to use Visual Basic for Excel, and from what I can tell (and what I have read) Visual Basic is not supported for Excel for Mac...but a new version will support it? I've heard of people using applescript as a substitute. Can somebody please enlighten me? I would hate to have to use Windows just to use Visual Basic on Excel.
    --
    My Mac: MacBook Intel Core 2 Duo 2.2 GHz 4GB RAM OS X 10.6 (Snow Leopard)

  2. #2

    chscag's Avatar
    Member Since
    Jan 23, 2008
    Location
    Keller, Texas
    Posts
    49,415
    Specs:
    Late 2013 27" iMac, iPad 3, iPhone 6s+, iPhone 6+, 3 iPods, Sierra
    Break out your Windows disk then.... because MS Office 2008 does not support VB (thanks MS), hence, no macros. (MS Office 2004 does support VB.) Yes, you can use Apple script but it's not the same and IMO, does not work well.

    The next version of MS Office (2011) should be on the market sometime this Fall. MS promises VB is back along with some other nice additions. We'll just have to wait until then.

    Regards.

  3. #3

    toMACsh's Avatar
    Member Since
    Jul 30, 2009
    Location
    Wisconsin
    Posts
    6,199
    Specs:
    Mac Mini (Late 2014) 2.6GHz Intel Core i5 Memory: 8GB 1600MHz DDR3
    If you need it sooner, Office 204 does support VBA, but you'd have to find a used copy since it's not sold by MS anymore.

  4. #4


    Member Since
    Jan 12, 2010
    Posts
    12
    Quote Originally Posted by chscag View Post
    Break out your Windows disk then.... because MS Office 2008 does not support VB (thanks MS), hence, no macros. (MS Office 2004 does support VB.) Yes, you can use Apple script but it's not the same and IMO, does not work well.

    The next version of MS Office (2011) should be on the market sometime this Fall. MS promises VB is back along with some other nice additions. We'll just have to wait until then.

    Regards.
    Ouch. I just installed office on Windows running through VMWare Fusion. This is painful. MS is doing their best to force Mac users to use Windows for business applications.
    --
    My Mac: MacBook Intel Core 2 Duo 2.2 GHz 4GB RAM OS X 10.6 (Snow Leopard)

  5. #5


    Member Since
    May 20, 2004
    Posts
    243
    Specs:
    iMac 21" 8GB, MBP 15" 2.5 Penryn, 4 GB/180 GB
    Also, with Office 2004, it uses VB 5 which is the same as using MS Office 97. Office 2000/2002/2003 on Windows uses VB 6. So as long as whatever is done on the Windows side is compatible with Office 97, then it should work in Mac Office 2004.
    Mellel 3, NWP 2, Scrivener 2.3.1, Tinderbox 5.11.2
    LibreOffice 3.6, Accordance 10.0, Adobe CS4, DTP 2.4.3
    OS X 10.8.2

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Visual Basic keyboard shortcuts on Mac
    By carissa in forum OS X - Apps and Games
    Replies: 1
    Last Post: 01-23-2012, 12:46 PM
  2. data analysis in microsoft excel 2008 for mac
    By bonvoyage in forum OS X - Apps and Games
    Replies: 3
    Last Post: 01-07-2010, 10:07 AM
  3. Microsoft Expressions Web and Visual Basic software for Mac?
    By lonelysith66 in forum OS X - Operating System
    Replies: 3
    Last Post: 12-14-2009, 09:14 AM
  4. Replies: 3
    Last Post: 05-13-2008, 05:32 PM
  5. Excel and visual basic liburary
    By elrussell in forum Running Windows (or anything else) on your Mac
    Replies: 1
    Last Post: 02-25-2008, 08:30 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •