In this video, I show how to use the Hyperlink Function in excel to create hyperlinks to every subfolder in a folder, using the command prompt to extract the list of all the folders into Excel. Surely PowerQuery can do the Extraction, but I like to be different
The workbook can be found here:
drive.google.com/file/d/1Y2DK...
• Create HYPERLINKS to a... Using the hyperlink function
#HyperlinkFunction
#Excel
#FolderList
Негізгі бет Create HYPERLINKS to all subfolders in a folder (CMD to extract list, no PQuery ) - Microsoft Excel
Пікірлер: 21