User Profile
cmlobo_sr_sf
Copper Contributor
Joined Aug 10, 2020
User Widgets
Recent Discussions
vba microsoft.mashup.oledb.1 provider is not registered on the local machine
Hello, some moths ago the following vba script stop working: sub auto_open ActiveWorkbook.Connections("Query - Query1").Refresh end sub the error message is : microsoft.mashup.oledb.1 provider is not registered on the local machine Query1 its a power query connection The Problem is that when the excel starts que .NET Framework isn't loaded. the command : ActiveWorkbook.RefreshAll , works but i have multiple connections and want them updated in a specific order i tried calling the command bar : Application.CommandBars("Queries and Connections").Visible=True it does not work I tried loading the command bar using sendkeys : Public Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As LongPtr) 'For 64 Bit Systems Sub refresh_sequence() ActiveWorkbook.Sheets(1).Select SendKeys "%apnl", True Sleep 1000 ActiveWorkbook.Connections("Query - Query1").Refresh ActiveWorkbook.Connections("Query - Query3").Refresh ActiveWorkbook.Connections("Query - Query2").Refresh End Sub the sendkeys when alone it loads the command bar and NET Framework, but when i combined sendkeys with query Refresh, never got the net framework loaded before query refresh command could be executed. I spent hour trying to find a solution but nothing ... i suspect that my inicial code spot working because an update of office 365 my office version is: Version 2009 (build 13130.20000 click-to-Run) Beta Channel This excel files are automated reportes this a specific refresh sequence and now i cant update automatically, i am updating them manually and i am losing my mind Best Regards CarlosSolved40KViews2likes9Comments
Recent Blog Articles
No content to show