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:
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
Негізгі бет Hyperlink in excel to all subfolders in a folder+PowerQuery+VBA
Пікірлер: 8