Extract Data with Power Query Using VBA

[Nyavor Kennedy]

I have a text file named text.txt and I want to write a vba code that will extract data from this file using power query, apply a filter on the column "Product" where the product to be filtered is "PLP" and then load the resulting data to a new worksheet. Any help?

 

[Chihiro]

Welcome to the forum.

No need for VBA to apply steps to PowerQuery. PowerQuery will reproduce steps applied within the editor.

Only piece of VBA needed is to refresh the query built using PowerQuery (if required, I generally have it set to refresh on workbook open, via Query property instead of VBA).

Upload sample workbook and the text file to get more specific help.

 

[Nyavor Kennedy]

Many thanks Chihiro.