Does VBA suck or is it just me

Discussion in 'NZ Computing' started by Reg, Feb 23, 2006.

  1. Reg

    Reg Guest

    Over the years I have done a bit of programming in C++ and more recently
    PHP. I love playhing about in these languages.
    Right now I have undertaken to do some work on an Access database that
    requires me to delve into VBA. I have Letwin Getz and Gilbert's Access 97
    Developers Handbook to guide me but it all really sets my teeth on edge.
    Obviously I'm not a professional developer and have had no formal training
    in programming but I wonder what is the opinion of the professionals out
    there. Does VBA suck compared to C++ and PHP or is it just that I am at the
    bottom of the learning curve and may yet come to love it?

    Reg
     
    Reg, Feb 23, 2006
    #1
    1. Advertising

  2. Reg

    Allistar Guest

    Reg wrote:

    > Over the years I have done a bit of programming in C++ and more recently
    > PHP. I love playhing about in these languages.
    > Right now I have undertaken to do some work on an Access database that
    > requires me to delve into VBA. I have Letwin Getz and Gilbert's Access 97
    > Developers Handbook to guide me but it all really sets my teeth on edge.
    > Obviously I'm not a professional developer and have had no formal training
    > in programming but I wonder what is the opinion of the professionals out
    > there. Does VBA suck compared to C++ and PHP or is it just that I am at
    > the bottom of the learning curve and may yet come to love it?
    >
    > Reg


    Yes, and yes.

    Allistar.
     
    Allistar, Feb 23, 2006
    #2
    1. Advertising

  3. Reg

    Dave Doe Guest

    In article <vQfLf.152131$>,
    says...
    > Over the years I have done a bit of programming in C++ and more recently
    > PHP. I love playhing about in these languages.
    > Right now I have undertaken to do some work on an Access database that
    > requires me to delve into VBA. I have Letwin Getz and Gilbert's Access 97
    > Developers Handbook to guide me but it all really sets my teeth on edge.
    > Obviously I'm not a professional developer and have had no formal training
    > in programming but I wonder what is the opinion of the professionals out
    > there. Does VBA suck compared to C++ and PHP or is it just that I am at the
    > bottom of the learning curve and may yet come to love it?


    Well... 2006 - 1997 = 9 - in computing terms, that's pretty old :)

    The VBA in Office 2003 is um.. somewhat different now. Regardless, it's
    still pretty easy. I find it's easy to pick up if you record a few
    macros, then break out into the code - and away yer go. I'd also say
    there's huge differences between C++ and PHP! - PHP is *not* strongly
    typed like C++ - you'll see a lot of spaghetti PHP 'code' out there.

    --
    Duncan
     
    Dave Doe, Feb 23, 2006
    #3
  4. Reg

    thingy Guest

    Reg wrote:
    > Over the years I have done a bit of programming in C++ and more recently
    > PHP. I love playhing about in these languages.
    > Right now I have undertaken to do some work on an Access database that
    > requires me to delve into VBA. I have Letwin Getz and Gilbert's Access 97
    > Developers Handbook to guide me but it all really sets my teeth on edge.
    > Obviously I'm not a professional developer and have had no formal training
    > in programming but I wonder what is the opinion of the professionals out
    > there. Does VBA suck compared to C++ and PHP or is it just that I am at the
    > bottom of the learning curve and may yet come to love it?
    >
    > Reg
    >
    >


    I thought it sucked myself, I avoid VBA....I did not like java much
    either so avoid it too, my favourite so far is perl.

    regards

    Thing
     
    thingy, Feb 23, 2006
    #4
  5. Reg

    JohnO Guest

    thingy wrote:
    > Reg wrote:
    > > Over the years I have done a bit of programming in C++ and more recently
    > > PHP. I love playhing about in these languages.
    > > Right now I have undertaken to do some work on an Access database that
    > > requires me to delve into VBA. I have Letwin Getz and Gilbert's Access 97
    > > Developers Handbook to guide me but it all really sets my teeth on edge.
    > > Obviously I'm not a professional developer and have had no formal training
    > > in programming but I wonder what is the opinion of the professionals out
    > > there. Does VBA suck compared to C++ and PHP or is it just that I am at the
    > > bottom of the learning curve and may yet come to love it?
    > >
    > > Reg
    > >
    > >

    >
    > I thought it sucked myself, I avoid VBA....I did not like java much
    > either so avoid it too, my favourite so far is perl.
    >
    > regards
    >
    > Thing


    Yeah but perl sucks for whipping up a quick bit of office automation
    which VBA is very good for.
     
    JohnO, Feb 23, 2006
    #5
  6. Reg

    Nihil Guest

    On Thu, 23 Feb 2006 23:08:26 +1300, Reg wrote:

    > Over the years I have done a bit of programming in C++ and more recently
    > PHP. I love playhing about in these languages.
    > Right now I have undertaken to do some work on an Access database that
    > requires me to delve into VBA. I have Letwin Getz and Gilbert's Access 97
    > Developers Handbook to guide me but it all really sets my teeth on edge.
    > Obviously I'm not a professional developer and have had no formal training
    > in programming but I wonder what is the opinion of the professionals out
    > there. Does VBA suck compared to C++ and PHP or is it just that I am at the
    > bottom of the learning curve and may yet come to love it?
    >
    > Reg


    It has it's purpose, but if you try and use it for something it wasn't
    really intended for, then of course it's going to suck.

    -N
     
    Nihil, Feb 23, 2006
    #6
  7. Reg

    Nihil Guest

    On 23 Feb 2006 11:29:09 -0800, JohnO wrote:

    > thingy wrote:
    >> Reg wrote:
    >>> Over the years I have done a bit of programming in C++ and more recently
    >>> PHP. I love playhing about in these languages.
    >>> Right now I have undertaken to do some work on an Access database that
    >>> requires me to delve into VBA. I have Letwin Getz and Gilbert's Access 97
    >>> Developers Handbook to guide me but it all really sets my teeth on edge.
    >>> Obviously I'm not a professional developer and have had no formal training
    >>> in programming but I wonder what is the opinion of the professionals out
    >>> there. Does VBA suck compared to C++ and PHP or is it just that I am at the
    >>> bottom of the learning curve and may yet come to love it?
    >>>
    >>> Reg
    >>>
    >>>

    >>
    >> I thought it sucked myself, I avoid VBA....I did not like java much
    >> either so avoid it too, my favourite so far is perl.
    >>
    >> regards
    >>
    >> Thing

    >
    > Yeah but perl sucks for whipping up a quick bit of office automation
    > which VBA is very good for.


    I'm not really a proponent of any one language. I have an open mind and the
    tools I use vary from project to project depending on the requirements and
    budget. I may use vb, vba, vb.net, c, C++, or whatever. I just depends!

    I'm a self-employed programmer. But I don't advertise or promote myself as
    a programmer, I promote myself as a solution provider.

    -N
     
    Nihil, Feb 23, 2006
    #7
  8. Reg

    Enkidu Guest

    Reg wrote:
    >
    > Over the years I have done a bit of programming in C++ and more recently
    > PHP. I love playhing about in these languages.
    > Right now I have undertaken to do some work on an Access database that
    > requires me to delve into VBA. I have Letwin Getz and Gilbert's Access 97
    > Developers Handbook to guide me but it all really sets my teeth on edge.
    > Obviously I'm not a professional developer and have had no formal training
    > in programming but I wonder what is the opinion of the professionals out
    > there. Does VBA suck compared to C++ and PHP or is it just that I am at the
    > bottom of the learning curve and may yet come to love it?
    >

    VBA is a cut down version of Visual Basic tailored to do backend things
    in Excell, Access and whatnot. It is useful for quick short stuff, I'd say.

    Cheers,

    Cliff
     
    Enkidu, Feb 23, 2006
    #8
  9. Reg

    Enkidu Guest

    thingy wrote:
    >
    > I thought it sucked myself, I avoid VBA....I did not like java much
    > either so avoid it too, my favourite so far is perl.
    >

    Um, you are comparing an application 'helper' language with a specialist
    enterprise class application development language and a language
    designed to do a myriad of tasks pretty well and be a 'swiss knife' of
    programming.

    Three different things, thingy! Three different things!

    Cheers.

    Cliff
     
    Enkidu, Feb 23, 2006
    #9
  10. Reg

    Nihil Guest

    On Fri, 24 Feb 2006 09:26:51 +1300, Enkidu wrote:

    > thingy wrote:
    >>
    >> I thought it sucked myself, I avoid VBA....I did not like java much
    >> either so avoid it too, my favourite so far is perl.
    >>

    > Um, you are comparing an application 'helper' language with a specialist
    > enterprise class application development language and a language
    > designed to do a myriad of tasks pretty well and be a 'swiss knife' of
    > programming.
    >
    > Three different things, thingy! Three different things!
    >
    > Cheers.
    >
    > Cliff


    You're on to it, yes, it does help to only compare apples with apples :)

    -N
     
    Nihil, Feb 23, 2006
    #10
  11. Reg

    Rob J Guest

    In article <vQfLf.152131$>,
    says...
    > Over the years I have done a bit of programming in C++ and more recently
    > PHP. I love playhing about in these languages.
    > Right now I have undertaken to do some work on an Access database that
    > requires me to delve into VBA. I have Letwin Getz and Gilbert's Access 97
    > Developers Handbook to guide me but it all really sets my teeth on edge.
    > Obviously I'm not a professional developer and have had no formal training
    > in programming but I wonder what is the opinion of the professionals out
    > there. Does VBA suck compared to C++ and PHP or is it just that I am at the
    > bottom of the learning curve and may yet come to love it?


    VBA does suck, as apart from being based on the loathsome BASIC
    language, it is a deliberately crippled edition of Visual Basic that MS
    would love to make you upgrade to.

    I have done a lot of VBA but only to support MS Access databases. If you
    want to write a full blown application that works with an Access
    database, better to use VB or VC++ (even though I loathe both of those
    environments).
     
    Rob J, Feb 23, 2006
    #11
  12. Reg

    AD. Guest

    I'm not so sure about VBA really being that good for Office Automation.
    The only reason it seems that way is because that is what is supplied
    in MS Office, and Office itself has pretty good automation APIs. It
    ain't anything to do with VBA as a language.

    Python has a good reputation for an embeddable automation language
    especially in graphic apps - eg Blender, The GIMP etc. It gets used a
    lot in the workflow for movie effects as well apparently.

    --
    Cheers
    Anton
     
    AD., Feb 24, 2006
    #12
  13. Reg

    JohnO Guest

    AD. wrote:
    > I'm not so sure about VBA really being that good for Office Automation.
    > The only reason it seems that way is because that is what is supplied
    > in MS Office, and Office itself has pretty good automation APIs. It
    > ain't anything to do with VBA as a language.
    >
    > Python has a good reputation for an embeddable automation language
    > especially in graphic apps - eg Blender, The GIMP etc. It gets used a
    > lot in the workflow for movie effects as well apparently.
    >
    > --
    > Cheers
    > Anton


    It's not so much the language... its the solution as Nihil said.
    Somebody comes to you and says 'I want the following automated
    functionality in my spreadsheet'. use anything but VBA and you are
    making life hard, Personally I think VBA is a bit tatty but if you want
    to automate office applications, and in the REAL world that means MS
    Office, then its still the best bet.
     
    JohnO, Feb 24, 2006
    #13
  14. Reg

    Reg Guest

    OK - thanks everybody. From your replies I guess my frustration is not
    entirely down to me, though much of it has to be, given my lack of training.
    Allstar put it very succinctly.
    Reg
     
    Reg, Feb 24, 2006
    #14
  15. Reg

    thingy Guest

    JohnO wrote:
    > thingy wrote:
    >
    >>Reg wrote:
    >>
    >>>Over the years I have done a bit of programming in C++ and more recently
    >>>PHP. I love playhing about in these languages.
    >>>Right now I have undertaken to do some work on an Access database that
    >>>requires me to delve into VBA. I have Letwin Getz and Gilbert's Access 97
    >>>Developers Handbook to guide me but it all really sets my teeth on edge.
    >>>Obviously I'm not a professional developer and have had no formal training
    >>>in programming but I wonder what is the opinion of the professionals out
    >>>there. Does VBA suck compared to C++ and PHP or is it just that I am at the
    >>>bottom of the learning curve and may yet come to love it?
    >>>
    >>>Reg
    >>>
    >>>

    >>
    >>I thought it sucked myself, I avoid VBA....I did not like java much
    >>either so avoid it too, my favourite so far is perl.
    >>
    >>regards
    >>
    >>Thing

    >
    >
    > Yeah but perl sucks for whipping up a quick bit of office automation
    > which VBA is very good for.
    >


    Assuming you are on a MS platform of course.....

    Perl will run on just about anything.

    regards

    Thing
     
    thingy, Feb 24, 2006
    #15
  16. Reg

    Enkidu Guest

    AD. wrote:
    >
    > I'm not so sure about VBA really being that good for Office Automation.
    > The only reason it seems that way is because that is what is supplied
    > in MS Office, and Office itself has pretty good automation APIs. It
    > ain't anything to do with VBA as a language.
    >
    > Python has a good reputation for an embeddable automation language
    > especially in graphic apps - eg Blender, The GIMP etc. It gets used a
    > lot in the workflow for movie effects as well apparently.
    >

    I almost prefer VBA to Python. Python is horrible.

    Cheers,

    Cliff
     
    Enkidu, Feb 24, 2006
    #16
  17. Reg

    Rob J Guest

    In article <>,
    says...
    > I'm not so sure about VBA really being that good for Office Automation.


    You mean OLE type stuff?
     
    Rob J, Feb 24, 2006
    #17
  18. Reg

    Rob J Guest

    In article <g7vLf.154156$>,
    says...
    > OK - thanks everybody. From your replies I guess my frustration is not
    > entirely down to me, though much of it has to be, given my lack of training.
    > Allstar put it very succinctly.


    VBA has the advantage that it comes with office and is supported by MS.
    You can do stuff with other packages, but they don't always work so
    well.

    I did a lot of stuff with VBA in Access, but always got frustrated with
    the language itself, which is not very OO when this is where the trend
    it these days.
     
    Rob J, Feb 24, 2006
    #18
  19. Reg

    AD. Guest

    Rob J wrote:
    > In article <>,
    > says...
    >
    >>I'm not so sure about VBA really being that good for Office Automation.

    >
    >
    > You mean OLE type stuff?


    Yep - my point was that the good part of that automation is the fairly
    comprehensive object model - not the language itself.

    I've lost touch with how the latest MS Office versions work though - it
    is now all language independant CLR stuff now? That would be pretty cool.

    --
    Cheers
    Anton
     
    AD., Feb 24, 2006
    #19
  20. Reg

    AD. Guest

    Enkidu wrote:

    > I almost prefer VBA to Python. Python is horrible.


    Any particular reason?

    --
    Cheers
    Anton
     
    AD., Feb 24, 2006
    #20
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Joyce

    VBA for Access

    Joyce, May 21, 2004, in forum: Microsoft Certification
    Replies:
    0
    Views:
    483
    Joyce
    May 21, 2004
  2. Richard Owlett
    Replies:
    0
    Views:
    421
    Richard Owlett
    Oct 1, 2003
  3. PWB

    VBA/Gedza.A

    PWB, Sep 27, 2004, in forum: Computer Support
    Replies:
    4
    Views:
    1,011
    The Tech Guy
    Sep 27, 2004
  4. A. Blundon

    MS Excel 2003 VBA in 64 bit

    A. Blundon, Jun 2, 2006, in forum: Windows 64bit
    Replies:
    3
    Views:
    926
    A. Blundon
    Jun 2, 2006
  5. Howard31

    Excel VBA Certification

    Howard31, Aug 2, 2009, in forum: Microsoft Certification
    Replies:
    2
    Views:
    6,747
    TBone
    Aug 10, 2009
Loading...

Share This Page