Sunday, March 8, 2020

Alert -- Issues with some RCHGetElementNumber() elements and some smfUpdateDownloadTable processing

Microsoft has made some changes to the VBA function EVALUATE(). Both the RCHGetElementNumber() function and the smfUpdateDownloadTable macro utilize the EVALUATE() function for some processing paths.

What is happening is that if an add-in function is the first thing in the string passed to the EVALUATE() string, it doesn't evaluate the string and return the result. It simply returns the string that was passed to it.

To see if your version of EXCEL does this, try the following add-in function:

=smfEval("smfStrExtr(""123"",""1"",""3"")")

If that returns a value of "2", you are not affected (yet). However, if it returns:

smfStrExtr("123","1","3")

...then you are affected.

I think I have a fix I can use, but I'm still thinking about whether it's the best way to do it.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.