VBA Language Definition RRS feed

  • Question

  • Hi, just a quick question


    Does there exist anywhere a formal definition of the VBA language? It would be really useful for my dissertation as i am writing a program that interprets macros so could do with something that would tell me, for example all the different ways that variables can be defined, or all the different types of statement that can be used etc.

    Any advice is much appreciated



    Tuesday, April 10, 2007 10:01 PM

All replies

  • Jeez, wouldn't that make it too easy? 

    Are you looking for information on VBA with the older versions of Office, or the brand new "VBA" which is basically just .NET code running under the MSO mechanism?  Which one are you working with?  If you're working in VB6, this unfortunately isn't the right forum for support.
    Wednesday, April 11, 2007 11:47 AM
  • Im working with VBA as used in the macro editor for Excel 2003... whatever that is Stick out tongue Just VBA as far as im concerned Wink


    You're right its not easy. Im only really looking to interpret the more basic statements but i still find myself constantly thinking of new ways that things could be written and hoped there was some kind of language definition to help me out. For example, when working on my variable declaration handler, it originally was initialised when it came across the 'Dim' keyword, then i remembered a variable might be initialised with 'const'... then realised those could be public or private etc etc etc. An official definition would help i think



    Wednesday, April 11, 2007 12:14 PM