Page 1 of 2 12 LastLast
Results 1 to 15 of 16

Thread: VBA TRAINING

  1. #1
    Star Lounger
    Join Date
    Jun 2001
    Location
    California
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VBA TRAINING

    I'm new to VBA and in need of training QUICKLY. I've previously been in the administrative support field and don't have any 'tech' friends to network with. Know of any good training companies/individuals? <img src=/S/help.gif border=0 alt=help width=23 height=15>

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: VBA TRAINING

    Try the VBA Developer's Handbook from Sybex. It will give you a lot of the basic stuff you need for using VBA with the Office suite and for automating one app from another. However, if you primarily intend to work with a particular application (i.e., Access, Excel, Word, etc.), you would be advised to get training and references on that particular application, since VBA varies by the app it runs in.
    Charlotte

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA TRAINING

    Please - Tell us where you live/work. If you are in San Diego, you won't need my list of trainers in Toronto.

  4. #4
    Star Lounger
    Join Date
    Jun 2001
    Location
    California
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA TRAINING

    I live/work in Silicon Valley. Should be pretty easy to find training wouldn't you think? Thanks in advance for anything you can give me! I can travel some, so don't limit the information you give me to just my area. Maybe the western states in general. Thanks again.

  5. #5
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA TRAINING

    What makes you think you need training? None of us have any training. We just start typing and sooner or later something works. Sort of like the tornado-in-the- junkyard model for aircraft assembly. Have you tried that method? It saves your employer lots of training budget money (which really impresses the CFO -- and you want to be in tight with the CFO, right?). And it keeps projects moving indefinitely...

    Seriously, if you can get your hands on a programming methodolgy reference (that's VBA specific), you'll be sure to get off to a good start. Nuts and bolts stuff like the VBA Handbook are indispensible. But if you are going to build an app, you might want to know that your foundation is solid before you perfect your technique.

    And when you find that reference, would you mind posting back so I can buy it, too.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: VBA TRAINING

    Well, if the application is Access, you can't go wrong with Access 97 Expert Solutions, by Stan Leszynski (yes, the naming convention Leszynski), regardless of which version of Access you're using. It not only contains code, but lays out a whole development framework for you projects.
    Charlotte

  7. #7
    Silver Lounger Charles Kenyon's Avatar
    Join Date
    Jan 2001
    Location
    Sun Prairie, Wisconsin, Wisconsin, USA
    Posts
    2,049
    Thanks
    124
    Thanked 119 Times in 116 Posts

    Re: VBA TRAINING

    Hi Tracy,

    You may want to check out the links at <A target="_blank" HREF=http://www.addbalance.com/word/wordwebresources#VBA> Word VBA resources</A>.

    Try to learn the applications you will be programming at an advanced level before you start programming. Otherwise, you'll be writing programs trying to handle tasks better (and more easily) performed by a built-in function.
    Charles Kyle Kenyon
    Madison, Wisconsin

  8. #8
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA TRAINING

    Thanks for that reference, Charlotte. And speaking of naming conventions, what's the difference between Leszynski and Reddick? Ketz, et al and MS seem to prefer Reddick. Is there a compelling reason to go with one over the other?
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: VBA TRAINING

    Well, originally the naming convention was published as the Leszynski-Reddick naming convention, and that's when I started using it. Somewhere along the way the principles must have disagreed on handling for certain prefixes because the two naming conventions went their own ways. Both versions have evolved as the object models have evolved, so neither is the same as it was originally. I mean, when L-R used bln for boolean, there wasn't any such animal as a balloon in the object model, so they didn't have to worry about confusion. I think one of them now uses bal for balloon and the other uses bln, but I wouldn't swear to it because I never use the pesky things.

    I don't like Reddick, but that's just a personal bias because I'm used to Leszynski. Leszynski sticks pretty closely to a 3-character prefix across all datatypes, like bln or boo for boolean, while Reddick apparently allows longer prefixes like bool for boolean and shorter ones like rs for recordset. And of course, Microsoft confuses the issue by using a horrible mixture of conventions (or NOT) in their samples and by recommending something that doesn't appear to be either for VB.

    Leszynski uses a 1 character tag ahead of the prefix for things like arrays and constants and to distinguish scope, while I see Reddick users using a con prefix for constants of all types instead of the cstr, etc., type of prefix the Leszynski method would suggest for a particular type of constant.

    Both conventions provide for levels of naming that I decline to use, like field names and function names. I think you can carry a good thing entirely too far. I stick to naming objects and variables using my convention of choice.

    I like the consistency of Leszynski and some of Reddick tags annoy me, so I use the LNC. It's mainly what you're used to and what makes the most sense to you. Of course, if you're in a large shop, you may not have any choice of the convention you use because it will be determined by your higher ups. But the most important thing is to use a convention and make sure you're consistent.

    It isn't even terriby important if you adhere absolutely to a particular accepted naming convention, just so whatever you use is consistent and comprehensible to anyone who has to read your code. I can *read* code that uses Reddick just as easily as I can read code that uses Leszynski. When I *write* it though, I use what feels natural and I don't change that unless there's a good reason.

    Phew! Maybe we ought to ask Drk for a smilie for getting down off from a soapbox. <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    Charlotte

  10. #10
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA TRAINING

    > Leszynski sticks pretty closely

    But charges $$$ for a copy of his naming conventions, while <A target="_blank" HREF=http://www.ldfinfo.com/aes.htm>this site has broken links to the conventions.

    Whereas earlier posting).


    As a programmer my first thought is to adopt an existing standard. If I don't have a standard for the language I'm using, I'll adopt the first one I can find.



    You're welcome to the soap box until the next time I want it.

  11. #11
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA TRAINING

    Tracy,

    You should try the Appdev website: lots of VBA stuff: training, videos, CD roms, courses..., even some free stuff to download.

    <A target="_blank" HREF=http://www.appdev.com/topics/product.asp?ID=9>appdev</A>

  12. #12
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: VBA TRAINING

    That's OK Chris, it's a big soap box. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    The link to www.ldinfo doesn't work anymore because Leszynskis firm was acquired by Kwery Corp, and they charge for everything. There are other sites for the LNC, and in fact <A target="_blank" HREF=http://www.helenfeddema.com/>Helen Feddema's site</A> has add-ins to apply the LNC to Access databases. Plus the book I mentioned, Access 97 Expert Solutions, has the whole thing in the book and on the CD.
    Charlotte

  13. #13
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: VBA TRAINING

    BTW, Chris, your use of the "$$$" causes your post to come through my Outlook rules flagged as junk mail. Uh ... no offense. <img src=/S/rofl.gif border=0 alt=rofl width=15 height=15>
    Charlotte

  14. #14

  15. #15
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA TRAINING

    Charlotte,

    That was actually a helpful tome...

    I've concluded that my hybrid is not going to relegate me to obscurity. As I've seen so often in code posted by others, to each his own -- and the "burden" (if there is one) in reading the code is up to the "borrower".

    Authors are such fiddle-faddle.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

Page 1 of 2 12 LastLast

Posting Permissions

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