Hyperlink in excel to all subfolders in a folder+PowerQuery+VBA
hyperlink in Excel to all subfolders - Using PowerQuery and VBA for an effectively dynamic solution to hyperlinking to all subfolders in a folder in Excel
Link to the workbook:
https://drive.google.com/file/d/1XWo9...
00:00 Introduction
00:23 Problem/Challenge description
01:20 Showing how to create a hyperlink
01:58 Using Get Data to get a list of subfolders
04:00 Making the solution more dynamic
06:11 Using the hyperlink function for dynamic hyperlinks
07:20 Showing a hyperlink to a file in 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 Concluding Thoughts
Watch video Hyperlink in excel to all subfolders in a folder+PowerQuery+VBA online without registration, duration hours minute second in high quality. This video was added by user ExcelMoments 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 936 once and liked it 58 people.