Hyperlink in excel to all subfolders in a folder+PowerQuery+VBA

[@IvanCortinas_ES]

As always Victor, very elegant resolution. "Small bricks" joined together creating a "large building". Thank you!!

[@ExcelMoments]

That's exactly how I put it to someone on Linkedin, a combination of several simple ideas

[@alexrosen8762]

Excellent!

[@ivanmamchych5802]

Great technique, Victor. Thank you. I was going to advice an additional check for presence/absence of trailing slash in the path (a user can put it or vise versa). But you solved this possible scenario by an elegant macro of folder selecting. Thumbs up 👍

[@ExcelMoments]

Absolutely, that's something I was going to add, but like you rightly observed, with VBA, we would not need to include that bit, but users can always be funny and may still choose to type in manually and cause issues

[@davidakomolafe3609]

Awesome as always!

[@sandroganci8817]

Thanks for the video, very interesting. Is it possible to create the hyperlink column and its formula in PowerQuery before loading the data into excel ?

[@ExcelMoments]

interesting question. That would be cool if it could be done, meaning PQ would have to have a hyperlink function and one can set it up in there, but I doubt that's possible, i just don't like saying IMPOSSIBLE (as at today) 😁 but once set-up, the 2nd column, the hyperlink column is always there and you don't need to do anymore to get the range to contract/expand as necessary