none
Will VBA be replaced in the future RRS feed

  • Question

  • Hello guys, I'm new to VBA but it gives me headaches because of that syntax and I'm hoping that we could develop with c# without using visual studio

    Wednesday, August 3, 2011 11:07 AM

All replies

  • VBA gives you headaches, but C# doesn't??
     
    Microsoft have no (public) plans to change the current setup. They have committed only that VBA will be in the next version of Office.
     

    Enjoy,
    Tony
    www.WordArticles.com
    • Proposed as answer by Shasur Sunday, August 7, 2011 6:21 AM
    Wednesday, August 3, 2011 12:41 PM
  • This question has been regularly asked for at least the last 15 years, and so far the answer has always been the same. That is, eventually MS announce that VBA will be included in the next version of Office or, more recently, "there are no plans to remove VBA from Office", which is the current standing.

    I suspect not even MS know how long VBA will be supported. Almost certainly it will be in the next version of Office, and probably for some future versions to come. But that's only an opinion

    Peter Thornton

    Wednesday, August 3, 2011 12:42 PM
    Moderator
  • If you want to develop using C# without visual studio try looking at Excel DNA.

    http://exceldna.codeplex.com/


    Charles Excel MVP The Excel Calculation Site http://www.decisionmodels.com/
    Wednesday, August 3, 2011 3:03 PM
  • Microsoft has not yet removed XLM (Excel4Macros) from Excel after almost 20 years, so at least from Excel's standpoint, it seems that VBA will be with us for a long time. I hear though that there are plans in the works for all kinds of HTML5 and related alternate schemes for controlling Office.

    Jon Peltier, Microsoft Excel MVP
    Peltier Technical Services, Inc.
    Peltier Tech Blog

    • Proposed as answer by Shasur Sunday, August 7, 2011 6:22 AM
    Friday, August 5, 2011 4:31 PM
  • Agree that VBA has a life left to be live. Not just VBA, even VB.NET will be a headache for a C# developer. Someone who is accustomed to braces will find tough to have many 'ends' - End If, End Sub etc and many more


    http://www.vbadud.blogspot.com http://www.dotnetdud.blogspot.com
    Sunday, August 7, 2011 6:24 AM
  • If or when Microsoft adds VB.net to Excel as an alternative built-in programming tool, you can bet that C# will also be included. The developer will have a choice.

    Jon Peltier, Microsoft Excel MVP
    Peltier Technical Services, Inc.
    Peltier Tech Blog

    Sunday, August 7, 2011 1:23 PM