Hi,
I have a code which regularly connects and refreshes a worksheet to an API. In the code I block alerts by using ("Application.DisplayAlerts = False") so that it continues running and refreshing in case of issues. However, it still stops every now and then after an error ("[Datasource error] The remote name could not be resolved") after which i still need to click "OK" before it continues.
In the Power Query Editor / Advanced Editor i have already included code to allow for longer timeout (5 minutes; "[Timeout=#duration(0,0,5,0)]"), which reduced the number of disruptions but did not fully block.
How can i avoid these pop ups and ensure the macro keeps running even when the remote name can (temporarily) not be resolved?
Thanks
Valentino
I have a code which regularly connects and refreshes a worksheet to an API. In the code I block alerts by using ("Application.DisplayAlerts = False") so that it continues running and refreshing in case of issues. However, it still stops every now and then after an error ("[Datasource error] The remote name could not be resolved") after which i still need to click "OK" before it continues.
In the Power Query Editor / Advanced Editor i have already included code to allow for longer timeout (5 minutes; "[Timeout=#duration(0,0,5,0)]"), which reduced the number of disruptions but did not fully block.
How can i avoid these pop ups and ensure the macro keeps running even when the remote name can (temporarily) not be resolved?
Thanks
Valentino