Page 2 of 2 FirstFirst 12
Results 16 to 26 of 26
  1. #16
    New Lounger afrolick's Avatar
    Join Date
    Dec 2011
    Location
    Rolla, MO
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Gary,
    I really like Dilbert. I've done quite a bit of programming in VBA and VB6 but not .NET so I'm kinda lost in .NET. Structured programming baffles me.

  2. #17
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    6,058
    Thanks
    196
    Thanked 766 Times in 700 Posts
    Allen,

    Let me also extend a welcome to the lounge.

    I've always been taught that structured programming is as simple as the concept on one way in one way out. In more technical terms no GOTOs! Although, with VBA that's kinda hard if you're going to do any error trapping, but at least keep it to that only! Now Object Oriented Programming that still gives me headaches when you get to classes, inheritance, and polymorphism
    May the Forces of good computing be with you!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


  3. #18
    New Lounger afrolick's Avatar
    Join Date
    Dec 2011
    Location
    Rolla, MO
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Exclamation VBA Excel Online classes

    Hey Dick,
    If your interested in spending anywhere from INR 4,000 ($75.73 US), to INR 14,000 ($265.06) as of Jan, 09 2012 at Chadoo.org.
    http://chandoo.org/wp/vba-classes/
    Just thought I'd put that out there.

    Ciao, Allan

  4. #19
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    Pittsford,NY
    Posts
    703
    Thanks
    306
    Thanked 25 Times in 19 Posts
    Allan:
    Thanks for your interest. I'm working my way through the 50 cent book that an earlier respondant
    posted.
    Best,
    Dick

  5. #20
    New Lounger afrolick's Avatar
    Join Date
    Dec 2011
    Location
    Rolla, MO
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    np

  6. #21
    New Lounger
    Join Date
    Dec 2009
    Location
    Luling, LA
    Posts
    6
    Thanks
    0
    Thanked 2 Times in 2 Posts
    I have been programming for over 40 years so I have been where you are going. I started with some of the older mainframe languages including FORTRAN, COBOL, and PL/I. I have made the journey to PC's starting with the IBM XT and have programmed in most of the languages. I have developed in VB6, and Powerbuilder, and now mostly use VB.NET. I have used VBA. I used it today to query SQL Server to populate an excel spreadsheet with the query results.

    I have a couple of recommendations for you. First, you can not learn everything so focus on what you are trying to create. When you want to see how something is programmed, google is your best friend. Usually, if there is something that you want to do, someone else has already done it and posted it on the web. Books are OK but examples of working code are better. They will also give you an idea of what object oriented programming is about.

    Good luck and you can never stop learning.

  7. #22
    Lounger
    Join Date
    Apr 2002
    Location
    Polk City, Florida, USA
    Posts
    30
    Thanks
    3
    Thanked 2 Times in 1 Post
    Quote Originally Posted by Dick-Y View Post
    I'm a retired systems programmer and application programmer from way-back in IBM mainframe days.
    Back then, Cobol and such were verb-oriented (Move X to Y, for example.)

    In trying to teach myself VBA, I cant seem to get my head around object-orientation, which is a different
    way of approaching things.

    Can anyone recommend a good book or two for someone like myself, so that I can break through this
    mental road-block?
    Gosh, a doppelgänger. I spent 30 years writing mainframe systems code, lived in the Pittsford area, and have the same mental block with respect to object oriented programming. It's been terribly frustrating to think I once knew just about everything there was to know about the room-sized system I worked with, and now haven't the foggiest idea how any of my gadgets work or how to write even a small Excel macro. Thank you for opening our closet door -- I'll be following a lot of the tips given here.

    Mikey

  8. #23
    2 Star Lounger
    Join Date
    Feb 2010
    Location
    Iowa, USA
    Posts
    146
    Thanks
    1
    Thanked 1 Time in 1 Post
    I have long had the same question as the original questioner - how can I learn about VBA after years of FORTRAN, RPG, BASIC, and COBOL programming. But then I wondered if it was really necessary or worth the effort, especially for short simple programs to accomplish a simple task. Maybe this is off topic, but is a site and language like FreeBASIC, ( http://www.freebasic.net/ ) sufficient to accomplish simple programming tasks, or would the effort spent to understand FreeBasic be better spent working (again) at VBA? Thanks for any comments, or should I start a new topic for this question?

  9. #24
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    10,207
    Thanks
    129
    Thanked 1,145 Times in 1,054 Posts
    I usually tackle similar situations by purchasing a good reference book that you can use, not only at the moment you need it (now), but in the future. Having that is much better, in the long run.

    The web can be a good thing to tackle specific problems, and sometimes what you need is just that, but I feel it doesn't beat the comfort and comprehensiveness of a good book. That said, you can find some online resources for VBA. They seem more adequate than starting with FreeBasic. With your BASIC background, you will get the knack of VBA pretty quickly. Probably the harddest thing will be the concept of an object, but if you take a pragmatic approach (just decide that you need to create some "types of variables" and they will have properties and methods that you will use through a specific syntax), you will do fine.
    Last edited by ruirib; 2012-01-12 at 10:08.

  10. #25
    5 Star Lounger RussB's Avatar
    Join Date
    Dec 2009
    Location
    Grand Rapids, Michigan
    Posts
    658
    Thanks
    8
    Thanked 38 Times in 37 Posts
    Quote Originally Posted by Dick-Y View Post
    Can anyone recommend a good book or two for someone like myself, so that I can break through this
    mental road-block?

    Any suggestions will be gratefully received.

    Thanks,
    Dick
    I've been looking for more than 50 years, this is the BEST one I've found.
    Do you "Believe"? Do you vote? Please Read:
    LEARN something today so you can TEACH something tomorrow.
    DETAIL in your question promotes DETAIL in my answer.
    Dominus Vobiscum <))>(

  11. #26
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    Pittsford,NY
    Posts
    703
    Thanks
    306
    Thanked 25 Times in 19 Posts
    RussB:
    No fair Tebowing a thread; but that is the best one I know.
    Dick

    et cum spiritum tuorum <))>(

Page 2 of 2 FirstFirst 12

Posting Permissions

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