Results 1 to 2 of 2

Thread: Reference Power Query query in VBA

  1. #1
    Seeker ImkeF's Avatar
    Join Date
    Mar 2015
    Posts
    6
    Articles
    0
    Excel Version
    1811

    Reference Power Query query in VBA



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Is it possible to reference the content of a Power Query query in VBA just as in the reference of a Power Pivot data model, like this: “wbTarget.Model.Initialize”?
    In Excel 2010 I want to export the query result (>1,1 Mill rows) into a csv, but cannot use the way through the PP model as PQ unfortunately isn’t loading to it in this version.

    Thanks a million for your help!
    Imke


  2. #2
    Seeker ImkeF's Avatar
    Join Date
    Mar 2015
    Posts
    6
    Articles
    0
    Excel Version
    1811
    Think I found the answer in Kens blogpost 2014/10/22/refresh-power-query-with-vba:

    "..Power Query doesn’t have any VBA object model.."

    Very sad :-(

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •