Datasource Error from PowerQuery not caught by Excel VBA RRS feed

  • Question

  • Hi,

    I try to run a power query on an Excel (.xlsx) sheet. When the file returns an error (a data source error), I want to skip the refresh of the table and quietly continue my VBA routine. Somehow, VBA does not catch the data source error. What am I doing wrong? Is there a solution for this?


    Wednesday, May 15, 2019 4:34 PM