MGTexas123
New Member
- Joined
- Jan 1, 2020
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
If I run a VBA Macro in Excel that instructs a number of power queries in the workbook to refresh, how do I get the VBA code to move to the next step if a query refresh gets stuck (e.g. does not load)? Here is an example of the VBA code:
Sub New_Requests()
ActiveWorkbook.Connections("Query - New Requests").Refresh
ActiveWorkbook.Connections("Query - New Requests Export File to ACT").Refresh
End Sub
Thanks in advance for any help on this!
Matt
Sub New_Requests()
ActiveWorkbook.Connections("Query - New Requests").Refresh
ActiveWorkbook.Connections("Query - New Requests Export File to ACT").Refresh
End Sub
Thanks in advance for any help on this!
Matt