Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Kent, England
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Learning VBA (Office 2000)

    I am really only wanting to use VBA with Access & Excel. My "knowledge" consists of recorded macros with a bit of tinkering and that's all (plus some nice bits that I pick up off of here). So I really need to get the fundamentals into my head.

    My company are willing to shell out

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Learning VBA (Office 2000)

    If there is a good course available with a good instructor, and someone else is willing to pay for it, that is definitely the best way to go.
    Legare Coleman

  3. #3
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Learning VBA (Office 2000)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> TearsInTheRain

    <img src=/S/stop.gif border=0 alt=stop width=15 height=15> STOP it right now Legare is right. And I would add to his suggestion some more recording and some more tinkering.

    Try and think of a project, heck write an application that would emulate an ATM (Automated Teller Machine), where you can withdraw funds from your bank accounts and you can move and deposit funds in accounts.

    Make it as complex as you want to learn, try to change the behavior of this application by using different ways to do the same thing.

    After some more of this recording and tinkering, you will need some more recording and tinkering and then some less recording and more writing, but the tinkering will be constant or increase with the days.

    Good luck. Oh and take a picture of yourself NOW <img src=/S/smile.gif border=0 alt=smile width=15 height=15>. You will need it for moral support when your application stops working for some reason... <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

    Wassim <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Learning VBA (Office 2000)

    I agree with the rest of the folk here - do a course if you get a chance. VBA is a complex enough language that you really need a structured, live course where you can focus on that subject and nothing else for a few days. Doing it from a book or video or on your own, there will be constant interuptions, and you tend to go in great depth in a few places and never get a good overall view of the scope. In any event after doing a course, you will find the books of much greater value. One significant point too is that you can't record macros in Access in the same fasion as you do with Excel or Word. And code done with recording usually has to be modified to work in a more general environment. You have lots of fun ahead!
    Wendell

  5. #5
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Kent, England
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Learning VBA (Office 2000)

    Cheers Guys,

    An expensive course it is.

    Can anyone actually recommend a good company. I'm sure there's loads out there. It would probably have to be in London and judging by your profiles I don't expect Wendell, Legare or Wassim to be able to help
    Wassim - off topic - I went to a VERY nice club in NY once called the "VIP club" - amazing what $20 can get you.

    Anyway, thanks people!
    John

  6. #6
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Learning VBA (Office 2000)

    This is nowhere near as specific as I'd like, however......... When I was in the UK, attended a fair number of MSDN events. One of their main (& best) 3rd party sources of lecturers was a company that was based in Basingstoke, and had (I believe) the initials ICS. They all certainly tended to know what they were talking about and co-sponsored a Visual Studio 6 conference for example. Maybe you'll have some luck witnh a UK-based search engine, but a few searches have yet to turn them up. HTH
    Gre

  7. #7
    New Lounger
    Join Date
    Mar 2002
    Location
    Paisley, Scotland
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Learning VBA (Office 2000)

    You can learn Office VBA a lot cheaper than that if you are not averse to learning online with a remote tutor available for assessment and assistance.
    The course I have in mind is "Programming in Visual Basic" which is project based (8 in Total) and covers both VB and VBA also has additional miniprojects in excel etc. Cost

Posting Permissions

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