win 10 access 2007 what is this

[dogdays]

In a program I wrote many years ago I have this code

     [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=If]#If [/URL]  vba3 then
         some code here
      #end  if

What is [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=If]#If [/URL] vba3

tia Jack

 

[Ron Coderre]

It's conditional code that checks the version of VBA in Excel. You'd typically use that structure if you had code that would be run by users with different versions of Excel. Some code would run on XL2003 but not later...and vice versa.

Does that help?

 

[dogdays]

If the answer also applies to access VBA then yes.
How do I find what vba3 is/does?
Either way thank you for the response.

Jack

 

[Ron Coderre]

Yes....That structure applies to all MS Office VBA.
I haven't had to use that for so long that I've forgotten which versions of VBA pertain to versions of office.
Hopefully, this link will help:
https://en.wikipedia.org/wiki/Visual_Basic_for_Applications

 

[xenou]

vba is a subset of VB6. Don't think anything would be vb3 now.

 

[xenou]

Some interesting odds and ends related to this topic:
http://dailydoseofexcel.com/archives/2006/02/16/conditional-compilation-arguments/

It appears that Office 97 is VB5 (!) I'm not sure that vba3 is a predefined constant - this could have been some user-defined value (?)

Note: For the benefit of others reading the post, a basic introduction to conditional compilation is here:
https://docs.microsoft.com/en-us/do...ide/program-structure/conditional-compilation