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. Anonymous
    2019-08-19T14:20:15+00:00

    Thanks,

    I applied the update 4517297, but still got the error.

    it seems like the first reference to procedure/function in the code cause the error

    "Compile error:

    Method or data member not found"

    Was this answer helpful?

    0 comments
  2. Anonymous
    2019-08-19T10:27:19+00:00

    Hi,

    I have this issue too.

    It seems the last update fixed it in Win10, if a use Win7 i still get the error.

    Eran

    Was this answer helpful?

    0 comments
  3. Anonymous
    2019-08-16T23:35:11+00:00

    I just got a new update from our product team a few minutes ago:

    “The items on the Windows Release Information Dashboard have been updated”

    This means that for some Windows versions, the updates are already available.  If you check the dashboard for the specific Windows versions that interest you, you will learn if the fix is already available, or if it should be available in the coming days, or in “late August” for 19H1/1903.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2019-08-16T19:54:13+00:00

    Thanks again Scott.

    You get an anonymous "atta-boy" in this article (I have no association with the site)

    2019 08 16- Windows update causes Office VBA to fail

    https://office-watch.com/2019/windows-update-causes-office-vba-to-fail/

    Was this answer helpful?

    0 comments
  5. Anonymous
    2019-08-16T18:20:14+00:00

    Official update so far:

    "We will release a fix for this issue over the coming days as part of the ‘optional’ C update, which we are releasing early to address this issue. Note we are confirming which channels customers can pick up the update. Windows Update for Business customers will need to apply the update via Microsoft Update Catalog or Windows Server Update Services (WSUS)."

    Translation: We have a fix that we have tested on some platforms, and still waiting on testing in other platforms, and our release schedule will depend on which version of Windows you have, and how you obtain updates. In some cases, I think the release may even be this afternoon.  In other cases, maybe another week or so.  Or somewhere in between.

    That's all I have for now.

    Was this answer helpful?

    0 comments