Power Query VBA

[Chefsohail]

HI Team,

I have a set of URL's where i need to import the data from.

I have tried manually using power query and it works. However I need assistance with developing a VBA which pulls the details for all URL's in Column A. Removes the last 3 columns and then performs a Transpose on the result. Then use the first row as the header and data loads starting from Cell B2..

Can someone please guide how to do it, or if we have a code already in place..

 

[GraH]

There might be a way to do all with PQ.
Can you share some of the URLs? Can't guarantee but willing to give it a go.

 

[Chefsohail]

Thanx GraH for offering support, unfortunately due to the signed non disclosure agreement, i am not in a position to share the URL's... But if I atleast get the skeleton, I will able to workout something. I appreciate you helping me with this.

 

[GraH]

You have a PQ that runs for each of the URLs, right?
So for each is a Keyword in PQ...
Turn your single solution into a function and apply it to a table column where you have all URLs.
Something like

let GetURL (URL as text) =>
let
Your code
in
LastStepOfYourCode
in
GetURL

Note I am assuming a few things here...