• On TechRepublic: 10 email scams to watch out for
advertisement
January 23, 2007 3:25 AM PST

Keeping Visual Basic macros in Office for Mac OS X: Microsoft says macros will survive translation

by CNET staff
  • Font size
  • Print
  • 8 comments

As previously reported, Microsoft will drop support for Visual Basic macros in Office 2008 for Mac OS X. We subsequently reported that this state of affairs means that Office 2004 with the addition of an official converter for Open XML documents (due in beta form for Mac OS X this Spring) may remain the most cross-platform compatible version of Office in existence.

We have now confirmed with Microsoft representatives that macros will indeed survive the translation process offered by the converter. In other words, users will be able to run an Office 2007 for Windows documents with Visual Basic macros through the Mac OS X translator then open the documents in Office 2004 for Mac OS X and retain the macros.

As such, albeit far from ideal, running Office 2004 (either under Rosetta on Intel-based Macs or natively on PowerPC-based Macs) in tandem with the forthcoming translators will be the only option for users who absolutely need to retain compatibility with Visual Basic macros.

Feedback? Late-breakers@macfixit.com.

Previous coverage:

Resources

  • reported
  • Late-breakers@macfixit.com
  • Office 2004 with Open XML ...
  • More from Late-Breakers
  • Recent posts from MacFixIt
    Manage iCal's automatic e-mail generation for invitations
    CNET TV Apple Byte: Apple faces critics
    Weekly Utilities Update: Net Monitor, MiniUsage, TimeMachineEditor, more...
    Odds and Ends: Essential video codec packs for OS X
    Address Book: Unable to add, view contacts
    Persistent 'Faster Browser Search' overtaking Safari's default search
    Quick tip: Faster Time Machine backups
    MacFixIt Answers
    Add a Comment (Log in or register) (8 Comments)
    • prev
    • next
    by joemikeb January 23, 2007 6:17 AM PST
    NeoOffice has promised OpenXML and VBA support beginning with an early release program on February 27, 2007. So ti would appear there is a credible alternative to Office 2004 for compatibility with Microsoft Office 2007 for Windows files where VBA compatibility is a requirement. The only thing missing in NeoOffice is an email client to compete with Entourage.

    ---
    ____________



    [color:#009999] joemikeb [/color]: MacFixit Forums Moderator

    Reply to this comment
    by Lorraine January 23, 2007 6:17 AM PST
    >
    This is a reply to a previous comment by joemikeb


    NeoOffice's site is reporting that VBA support will be for Excel only.
    Reply to this comment
    by jon_bachelor January 23, 2007 7:31 AM PST
    My big question is - will VBA macros survive in any way (at all) in Office 2008 for Mac, or will you essentially be dealing with a completely broken document?

    What would the business sense of this be for Microsoft?? Are they trying to muscle over users to their Windows platform (even if via Parallels), and ultimately phasing out Office for Mac altogether?

    Does anyone know just how compatible NeoOffice is with Xcel documents & their Macros? Do you run into issues, or is it fairly seemless?

    Thanks all, and thanks to MacFixIt.com, one of my most cherished sites!! =)
    Reply to this comment
    by WhiteDog January 23, 2007 7:31 AM PST
    >
    This is a reply to a previous comment by jon_bachelor


    It is my guess that most people who use Office on the Mac do not use macros. Macros are a power user function which serve, by definition, a minority of users. Why Microsoft would want to disadvantage these people is a mystery, but Office 2008 without macros will be perfectly viable for most everyone else. The choice to abandon Macros on the Mac is, apparently, a hard-headed financial decision, typical of the Microsoft zeitgeist which invariably places quantity over quality. It does not signify lack of support for the Mac, merely lack of quality support for the Mac.

    ---
    Don't anthropomorphize computers.
    They hate that.
    Reply to this comment
    by tjrostaf January 23, 2007 7:31 AM PST
    >>
    This is a reply to a previous comment by WhiteDog


    Macros may be a power-user function in Office, but in WordPerfectMac 3.x and even in ClarisWorks/AppleWorks, both of which _record_ macros nicely (until AppleWorks macros went away with OSX), I have been using macros from the outset, and now find them essential. Among heavy Office users there are probably many who likewise depend on macros for their work flow? Let's hope NeoOffice can step into the breach.
    Reply to this comment
    by January 23, 2007 7:31 AM PST
    >
    This is a reply to a previous comment by jon_bachelor


    Yes,

    NeoOffice a port of OpenOffice is not only FREE, but I have used it for almost two years in a Microsoft Office environment. It is compatible with MS Office 2000, 2003.

    I have not yet tested its ability to port VBA macros back and forth, but as an alternative to Office it is a great product!
    Reply to this comment
    by RichL January 23, 2007 1:58 PM PST
    As is usually the case with MS...Mac users get stiffed in the end..
    Reply to this comment
    by wowgolds9872 October 5, 2008 7:51 PM PDT
    By the whole family to Zhang's defense capability, first of all to protect the safety of Saint Knight. Mmoinn to buy you the best of <a href="http://www.mmoinn.com"> wow gold </a> it! mmoinn.com is the most professional trade platform, it is simple and fast, you can save huge expenditures, so that you buy <a href="http://www.mmoinn.com"> cheapest wow gold </a>, This is an absolute value of the Oh! And you can easily find <a href="http://www.mmoinn.com"> world of warcraft sale </a> in the <a href="http://www.mmoinn.com/mmoinn_pl/"> Wow power leveling </a>, as soon as possible to allow you to flex its muscles in the Knights of St. it!
    Reply to this comment
    (8 Comments)
    • prev
    • next
    advertisement
    Click Here

    About MacFixIt

    MacFixIt is CNET's troubleshooting resource for all things Mac. The information here helps you navigate the ins-and-outs of Mac ownership with how-tos, troubleshooting information, news, reviews, and more.

    Add this feed to your online news reader