excelvbaoffice365powerqueryoffice365-apps

DynamicLoader It is not defined

I have a problem with running an .xlsm file with vba on autostart and powerquery, in some pcs w11 and w10, when I start the file returns the message "Dynamic Loader non è definito " the file, scripts and queries are not corrupted, as if launched in another pc everything works normally, I tried to uninstall office and install, but nothing the problem does not solve.[enter image description here][1]

This is the vba

Dim Connection As Variant

For Each Connection InActiveWorkbook.Connections
    Connection.OLEDBConnection.BackgroundQuery = False
Next
ActiveWorkbook.RefreshAll
' ****activity on excell**
    
Application.DisplayAlerts = False
    
xChiudi = True
    
Application.Quit

error message

resolution of the problem, because when confirm the message the process of excel remaining open and blocked

Solution

  • Getting the same error since 09.04 and guess what, there was an Office update on 08.04 https://learn.microsoft.com/de-de/officeupdates/current-channel
    Please check your working PC for the build number: Version 2503 (Build 18623.20178) doesn´t work anymore.

    For me, the query update works fine, excel also saves everything with:
    ThisWorkbook.Save added to VBA before Application.Quit

    so I force it by killing excel after my script.