Windows Update 2019-08 Cumulative Update has broken VBA code use case

Anonymous
2019-08-14T10:33:56+00:00

An issue with VBA code has started to be seen by some of my users and also by me this morning. I have tracked it down to have been caused by the latest 2019-08 Cumulative Update (e.g. KB4511553) and it is affecting all combinations of Windows and Office that I have seen so far- from Windows Server 2008 to Windows 10 & Office 2003(!) to Office 2016. 

The test code below demonstrates the problem. The method "Test" executes with no errors before the 2019-08 cumulative update is installed (or after it is uninstalled). However, after the update, the scenario of passing an empty ParamArray parameter to another method as a Variant parameter causes an error to be thrown on the declaration line of the second method. (Error 5: Invalid procedure call or argument).

Sub Test()

    Test1 "A", "B"   'Works OK with and without Windows Update

    Test1            'Fails after Windows Update

End Sub

Sub Test1(ParamArray P() As Variant)

    Test2 P

End Sub

Sub Test2(ByVal P As Variant)    'Error occurs on this line

End Sub

This is causing errors in my Microsoft Access application, but I have also tried this code in Word 2016 and the same issue occurs there too.

Can somebody validate this, please? I'm not really sure what the correct way of reporting this problem is.

Thanks

Chris

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

43 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom van Stiphout 40,216 Reputation points MVP Volunteer Moderator
    2019-08-15T01:45:56+00:00

    4512508 was also mentioned here: 

    https://docs.microsoft.com/en-us/windows/release-information/status-windows-10-1903

    Excerpt:

    Details Originating update Status History
    Apps using Visual Basic 6 (VB6), VBA, and VBScript may stop responding with error<br><br>After installing KB4512508, applications that were made using Visual Basic 6 (VB6), macros using Visual Basic for Applications (VBA), and scripts or apps using Visual Basic Scripting Edition (VBScript) may stop responding and you may receive<br> an "invalid procedure call error."<br><br><br><br><br><br>Affected platforms:<br><br><ul><br><li>Client: Windows 10, version 1903; Windows 10, version 1809; Windows 10 Enterprise LTSC 2019; Windows 10, version 1803; Windows 10, version 1709; Windows 10, version 1703; Windows 10 Enterprise LTSC 2016; Windows 10, version 1607; Windows 10 Enterprise LTSC<br> 2015; Windows 8.1; Windows 7 SP1</li><li>Server: Windows Server, version 1903; Windows Server, version 1809; Windows Server 2019; Windows Server, version 1803; Windows Server, version 1709 ; Windows Server 2016; Windows Server 2012 R2; Windows Server 2012; Windows Server 2008 R2 SP1; Windows Server<br> 2008 SP2</li></ul><br><br><br>Next steps: Microsoft is presently investigating this issue and will provide an update when available.<br><br> <br><br>Back to top OS Build 18362.295 <br><br> <br><br>August 13, 2019 <br><br>KB4512508 Acknowledged Last updated: <br><br>August 14, 2019 <br><br>03:34 PM PT

    Was this answer helpful?

    0 comments
  2. Anonymous
    2019-08-15T00:24:25+00:00

    I am a Sr. Escalation Engineer for Microsoft, and we are already working multiple support cases that have been opened for this issue.  The update that was released yesterday contained a change in the oleaut32.dll that mitigates a specific security exploit.

    Scot

    I forgot to ask, what is the KB number for that update?

    Was this answer helpful?

    0 comments
  3. Anonymous
    2019-08-14T23:15:15+00:00

    You're welcome.  I apologize for the historical behavior of "the castle" not communicating.  We're trying to change that.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2019-08-14T15:45:53+00:00

    Chris:

    Don't reply to the elizabeth lee contacts, they are machine generated spam

    What version and build number do you have after the updates are applied?

    What version Office do I have / What Version  Windows do I have

    Textify – A tool to capture “uncopiable” text from dialog boxes

    https://rammichael.com/textify

    Have you ever wanted to copy some text from a dialog box which doesn’t provide such functionality?

    Textify was created to solve this problem: you can point your mouse over the text, click on the mouse shortcut (Shift + Middle click by default), and get a selectable view of the text.

    <Rohn007: I’ve been using this tool for a while now. It is great for copying “uncopiable” text in dialog boxes, like version and build numbers.

    2018 11 26- 5 ways to find the exact version of Microsoft Office that you are using

    https://www.digitalcitizen.life/find-exact-version-microsoft-office

    This is a good article that covers Office 2003 to 2019.

    Was this answer helpful?

    0 comments
  5. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more