Load Power Query Result to a VBA Array RRS feed

  • Question

  • How does one load a Power Query result to an array in VBA without having to load the data in the worksheet(Data Connection only).
    Monday, September 11, 2017 10:58 PM


All replies

  • Do not sure that it is possible.

    If you made Connection Only, there is no results to load (just connection, right? and it is not a dataset, recordset etc.)

    If you load to the Data model, AFAIK you cannot get data from data model tables via VBA.

    Maxim Zelensky Excel Inside

    Thursday, September 14, 2017 11:40 AM
  • Sorry, you will need to load it to the sheet first.
    Thursday, September 14, 2017 10:48 PM