Hyperlink in Excel to all subfolders in a folderPowerQueryVBA

hyperlink in Excel to all subfolders – Using PowerQuery and VBA for an effective dynamic solution to create a hyperlink to all subfolders of a folder in Excel

Link to workbook:
https://drive.google.com/file/d/1XWo9CYe-kOlrOlxSRR7oc6rWW5OQIuRD/view?uspsharing

00:00 Presentation
00:23 Description of the problem/challenge
01:20 Show how to create a hyperlink
01:58 Use Get Data to get a list of subfolders
04:00 Make the solution more dynamic
06:11 Using the hyperlink function for dynamic hyperlinks
07:20 Displaying a hyperlink to a file in a folder
09:00 using ChatGPT for simple VBA code to open folder dialog
09:30 Adding VBA code to Excel workbook
11:34 Insert button to run code
12:32 Final thoughts

Please take the opportunity to connect and share this video with your friends and family if you find it useful.