Results 1 to 6 of 6
  1. #1
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Future of VBA in Office (Mac Office)

    For those that are interested - some news swirling around the latest version of Office for the Mac
    Slashdot
    MS Blog Post
    The Developer

    I admit to a little confusion on this issue, what pray tell, is the difference between not supporting VBA and keeping it Office?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Future of VBA in Office (Mac Office)

    VBA is the programming language in MS Office (but not any more in Office 2008 for the Mac), and it was also available to other developers who wanted to have a programming environment in their application, or who wanted to automate Office applications from outside Office. The latter options have now been discontinued in favor of .Net tools.
    There's such an enormous amount of VBA code in Word, Excel, Access etc. that it would be very difficult and dangerous for Microsoft to drop support for VBA in MS Office. They have threatened to do so more than once, but I don't see it happen anytime soon.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Future of VBA in Office (Mac Office)

    <hr>There's such an enormous amount of VBA code in Word, Excel, Access etc. that it would be very difficult and dangerous for Microsoft to drop support for VBA in MS Office. They have threatened to do so more than once, but I don't see it happen anytime soon.<hr>

    I honestly hope you are right...I'm just getting the grips of this language, and I surely do not want to start ALL over again with a new set of codes!! <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15>
    Regards,
    Rudi

  4. #4
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Future of VBA in Office (Mac Office)

    Well, they were able to "convince" users to migrate from WordBasic to VBA pretty quickly. And considering the speed and efficiency with which MS managed to all but erase VS6 from the annals of history, with the advent of .NET, I can't imagine they'd have any qualms in doing the same with VBA... probably to be replaced by some XML - .NET concoction.

    Alan

    An older article that may be of some interest: Schwieb Blog Archive Saying goodbye to Visual Basic

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Future of VBA in Office (Mac Office)

    The change from WordBasic to VBA took place when Word wasn't as dominant as it is now - WordPerfect was still a big player, AmiPro looked like it might become a contender. Moreover, they took great care to ensure that existing WordBasic code would continue to run with only minimal modifications. Up to now, Microsoft hasn't made it very easy to migrate from VBA to .Net.

    The article you refer to is interesting (I had read it before) but it's about VBA on the Mac, which has always had its own problems.

    We'll see.

  6. #6
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Future of VBA in Office (Mac Office)

    Agreed, but when/if they make the decision to change, I'm guessing that "legacy" support will start off strong, just as it did for VB6 -> VB.NET, in order to migrate a large user base to .NET, but then peter away over a few releases, just as WordBasic and XL4 Macro support did within Office.

    Alan

Posting Permissions

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