locked
Learning VBA.... where to begin?? RRS feed

  • Question

  • I have some very limited knowledge of VB, but I would like to learn VBA from the ground up, specifically with FrontPage. I just don't know where a good starting point is?

    Do I learn VB and then build upon that by learning VBA, or dig right into VBA?
    Do I learn VB.NET or VB in it's previous form?
    Is VBA much different in Office 2007 than previously?

    Any feedback would be greatly appreciated.

    Thank you,

    Greg
    Friday, November 2, 2007 5:10 PM

All replies

  • Hi,

    If you want to use code within office documents then concentrate on VBA.
    VBA in 2007 is the same as previous version with the obvious exception of new object model methods & properties.

    Some sites on the topic of VBA (excel orientated)
    http://www.mvps.org/dmcritchie/excel/getstarted.htm
    http://web.archive.org/web/20031204013634/support.microsoft.com/default.aspx?scid=/support/excel/content/vba101/default.asp
    http://www.cpearson.com/excel.htm
    http://j-walk.com/ss/excel/index.htm

    If you want to manipulate Office apps and documents then consider vb.net or more specifically VSTO
    http://xldennis.wordpress.com/


    Friday, November 2, 2007 7:21 PM
  • What about Access VBA ? Any suggestions on where to begin ?

    Saturday, November 3, 2007 3:29 PM
  • Seems like quite a good starting point for links to web resources.

    http://www.accessmvp.com/JConrad/accessjunkie/resources.html
    Saturday, November 3, 2007 4:58 PM
  • Ok, Here is how I did it, and while I'm still learning, I have mannaged to overcome some major hurtles with the project that I'm working on for my company.

     

    If you are new to programming, stick to VBA for sure.  If you are working with databases, particularly MS Access, then I would suggest following this path and read these books in the following order:

     

    1. Access 2003 (or 2007 depending on your virsion) Step By Step.  Its from Microsoft Press.  The Book comes with a CD full of examples that you work through as you learn so that you are getting experiance while you read.

     

    2.  Microsoft Access VBA Programming for the Absolute Beginner.  By Michael Vine.  In the week that I've had this book, I have learned enough to overcome so big stumping points.

     

    3. Access 2003 (or 07) Inside Out.  Also Microsoft Press.  While the first book will give you a general understanding of the program, this one will give you all the finer point workings

     

    Where you go from there is up to you, but that will at least help you get your feet wet, and you learn alot.

     

    Sunday, November 11, 2007 12:03 PM