Skip to content

Releases: ws-garcia/VBA-Expressions

VBA-Expressions v0.0.7

13 Mar 23:44
Compare
Choose a tag to compare

Bugs fixed:

  • Infinite loop when intercepting operators.

VBA-Expressions v0.0.6

11 Mar 03:56
Compare
Choose a tag to compare
  • Bug fixed: unable to catch special cases when required to evaluate the like operator.

VBA-Expressions v0.0.5

11 Mar 01:39
c347c00
Compare
Choose a tag to compare
  • Improvement: LIKE operator ($) support. Now, expressions such as Region $ 'C?????? *a' can be evaluated successfully.

VBA-Expressions v0.0.4

28 Feb 22:45
Compare
Choose a tag to compare
  • Improvement: ability to compare literal strings given in expressions.

VBA-Expressions v0.0.3

24 Feb 11:23
7782cb0
Compare
Choose a tag to compare
  • Bug fixed: cannot get correct function name.
  • Code update: removed redundant code.

VBA-Expressions v0.0.2

22 Feb 01:08
Compare
Choose a tag to compare
  • Minor code and documentation improvements

VBA-Expressions v0.0.1

20 Feb 20:41
Compare
Choose a tag to compare

Advantages

  • Easy to use and integrate.
  • Basic math operators: + - * / \ ^ !
  • Logical expressions: & (AND) | (OR) || (XOR)
  • Binary relations: < <= <> >= = >
  • More than 20 built-in functions: Max, Min, Avg, Sin, Ceil, Floor...
  • Very flexible: variables, constants and user-defined functions (UDFs) support.
  • Implied multiplication for variables, constants and functions: 5avg(2;abs(-3-7tan(5));9)-12pi-e+(7/sin(30)-4!)*min(cos(30);cos(150)) is valid expression; 5(2) is not.
  • Evaluation of arrays of expressions given as text strings, as in Java: curly brackets must be used to define arrays{{...};{...}}
  • Floating point notation input support: -5E-5, (1.434E3+1000)*2/3.235E-5 are valid inputs.
  • Free of external VBA dependencies: does not use dll.