Whither VBA?


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: Whither VBA?

  1. #1
    CJ Howorth Guest

    Whither VBA?


    One thing I haven't read about in the discussions of .Net is the fate of VBA.
    I'm a humble VBA developer working mostly in Access and Excel. I use VB
    6 at home on my own computer for some projects and at client sites when the
    client's willing to pay for a developer. I'm working with Office XP, and
    the flavors of VBA it's using are definitely VB6 compatible. Right now,
    VBA's a nice stepping stone to working with VB6 and I can write functions
    and classes in VBA that I can port up to straight VB with minimal changes,
    worries, and hassles. It doesn't sound like that will work as well with
    .Net. One particular concern is, starting with Access 2000, VBA moved to
    ADO objects from DAO. Now the advice is to move away from ADO in .Net.

    I'm as mercenary as any of us here. I can build apps in Access and Excel
    which require no knowledge of the parent program to use, and I enjoy doing
    it. I'm also pretty good with VB6, but right now that's not what people
    come to my employer for. Does anyone know if Microsoft is planning on making
    .Net-type changes to VBA? If so, when, and what happens to projects written
    in prior versions of VBA?

    CJ

  2. #2
    Rob Teixeira Guest

    Re: Whither VBA?



    They already have. Look on the MS website for VSA (Visual Studio for Applications).

    -Rob

    "CJ Howorth" <cjhoworth@yahoo.com> wrote:
    >
    >Does anyone know if Microsoft is planning on making
    >.Net-type changes to VBA?
    >
    >CJ



  3. #3
    Rob Teixeira Guest

    Re: Whither VBA?



    Only if you believe it's worth fearing without checking it out first.

    -Rob

    "Karl E. Peterson" <karl@mvps.org> wrote:
    >There you go again... fear-mongering... <g>
    >--
    >[Microsoft Basic: 1976-2001, RIP]
    >
    >
    >"Rob Teixeira" <RobTeixeira@@msn.com> wrote in message news:3c7566a6$1@10.1.10.29...
    >>
    >>
    >> They already have. Look on the MS website for VSA (Visual Studio for Applications).
    >>
    >> -Rob
    >>
    >> "CJ Howorth" <cjhoworth@yahoo.com> wrote:
    >> >
    >> >Does anyone know if Microsoft is planning on making
    >> >.Net-type changes to VBA?
    >> >
    >> >CJ

    >>

    >



  4. #4
    Karl E. Peterson Guest

    Re: Whither VBA?

    There you go again... fear-mongering... <g>
    --
    [Microsoft Basic: 1976-2001, RIP]


    "Rob Teixeira" <RobTeixeira@@msn.com> wrote in message news:3c7566a6$1@10.1.10.29...
    >
    >
    > They already have. Look on the MS website for VSA (Visual Studio for Applications).
    >
    > -Rob
    >
    > "CJ Howorth" <cjhoworth@yahoo.com> wrote:
    > >
    > >Does anyone know if Microsoft is planning on making
    > >.Net-type changes to VBA?
    > >
    > >CJ

    >



  5. #5
    Karl E. Peterson Guest

    Re: Whither VBA?

    I'll leave that to others to decide. <g>
    --
    [Microsoft Basic: 1976-2001, RIP]


    "Rob Teixeira" <RobTeixeira@@msn.com> wrote in message news:3c756cfa$1@10.1.10.29...
    >
    >
    > Only if you believe it's worth fearing without checking it out first.
    >
    > -Rob
    >
    > "Karl E. Peterson" <karl@mvps.org> wrote:
    > >There you go again... fear-mongering... <g>
    > >--
    > >[Microsoft Basic: 1976-2001, RIP]
    > >
    > >
    > >"Rob Teixeira" <RobTeixeira@@msn.com> wrote in message

    news:3c7566a6$1@10.1.10.29...
    > >>
    > >>
    > >> They already have. Look on the MS website for VSA (Visual Studio for

    Applications).
    > >>
    > >> -Rob
    > >>
    > >> "CJ Howorth" <cjhoworth@yahoo.com> wrote:
    > >> >
    > >> >Does anyone know if Microsoft is planning on making
    > >> >.Net-type changes to VBA?
    > >> >
    > >> >CJ
    > >>

    > >

    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center