The Notebook Review forums were hosted by TechTarget, who shut down them down on January 31, 2022. This static read-only archive was pulled by NBR forum users between January 20 and January 31, 2022, in an effort to make sure that the valuable technical information that had been posted on the forums is preserved. For current discussions, many NBR forum users moved over to NotebookTalk.net after the shutdown.
Problems? See this thread at archive.org.

    Questions about VBA for Mac

    Discussion in 'Apple and Mac OS X' started by t_roong, Jul 9, 2008.

  1. t_roong

    t_roong Newbie

    Reputations:
    0
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    5
    I am planing to buy a new laptop. Now, my laptop is Sony Vaio. However, I would love to try something new like Mac, but I want to make sure that Mac will not have problems about Windows compatibility with my work.

    I use a laptop for engineering purposes and programming, especially using Macro VBA in excel. I am not sure whether Macro Visual Basic in excel for mac is compatible with Windows.

    Your suggestions would be appreciated. Thank you very much. :)
     
    t_roong, Jul 9, 2008
    #1
  2. Tolkannn

    Tolkannn Notebook Evangelist

    Reputations:
    5
    Messages:
    358
    Likes Received:
    0
    Trophy Points:
    30
    Well that im not sure about but worst way if you run windows off of bootcamp natively you could... or run windows in mac :)
     
    Tolkannn, Jul 9, 2008
    #2
  3. tpoynton

    tpoynton Notebook Geek

    Reputations:
    44
    Messages:
    82
    Likes Received:
    0
    Trophy Points:
    15
    office 2008 does not support VBA at all! office 2004 does have VBA support, but it's a version (or half a version, I forget) behind windows, so there are some things that do not work; modeless userforms come to mind first, and I think the way userforms are closed/unloaded needs to be done a certain way (e.g. unload me). if there are any functions in the code that call up files (perhaps on a network), the mac might hiccup on it. there are workarounds for many things, but not all. my somewhat limited experience is that about 95% of code written on a windows version of office is compatible out of the box with a mac. much of the remaining incompatability can be worked around, while some just can not.

    the MacBU has pledged a return of VBA to future versions of Office for Mac...we'll see.

    long story short, dual booting might be the way to go!
     
    tpoynton, Jul 9, 2008
    #3