User Profile
cmlobo_sr_sf
Copper Contributor
Joined 5 years ago
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 CarlosSolved38KViews2likes9Comments
Groups
Recent Blog Articles
No content to show