none
Returned no data RRS feed

  • Question

  • hi,

       I using a macro to auto refresh excel data every 10 mins. Some times it shows a error message "This Web query returned no data. To modify the query, click OK, click the name of the external data range in the name box on the formula bar, and then click Edit Query on the External Data toolbar."  and it caused macro stop. please coach me how to disable/ignore this error message? thanks. I try to use "Application.displayalerts = flase" and "on error resume next" to ignore this message but it didn't works.

    macro as below

    Sub Macro1()

    Dim NewTime

    Application.DisplayAlerts = False

    NewTime = Now + TimeValue("00:10:00") 

    ActiveWorkbook.RefreshAll

    On Error Resume next

    Application.DisplayAlerts = True

    Application.OnTime NewTime, "Macro1"

     End Sub

    Thursday, August 18, 2016 10:12 AM

Answers

All replies