Create HYPERLINKS to all subfolders in a folder (CMD to extract list, no PQuery )

Create HYPERLINKS to all subfolders in a folder (CMD to extract list, no PQuery ) - Microsoft Excel

Рет қаралды 13,850

4 жыл бұрын

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

Пікірлер: 21

@haseebabbiii1 4 ай бұрын

You explained it brilliantly. I never realized that CMD is so easy and convenient to use.

@ExcelMoments 4 ай бұрын

Scary at first, easier when understood

@nonoobott8602 4 жыл бұрын

Amazing 👏. Thanks for walking us through the command prompt.....learned something new and it's brilliant. Thanks for sharing

@ExcelMoments 4 жыл бұрын

Thanks for the Feedback. It is one of my personal favourites

@tekylyfasharing9995 3 жыл бұрын

Thanks for sharing, that's brilliant

@ExcelMoments 3 жыл бұрын

Thank you for the feedback

@AccountingOnExcel 3 жыл бұрын

Hmmm...🤔🤔🤔 This man is good. Thanks for the value. Need to watch it over again sha

@ExcelMoments 3 жыл бұрын

Thanks for the feedback. feel free to watch many times :)

@hayberadjani5062 2 жыл бұрын

@@ExcelMoments how if you go to drive D there is one folder that folder have many folder inside of it you want to go to in last folder how to type a command like that situation sir...

@olukunlebabajide6089 4 жыл бұрын

Command prompt hmmmmmm! That's brilliant!

@ExcelMoments 4 жыл бұрын

Command Prompt is to Windows Explorer what VBA is to Excel :) Thanks for the feedback

@cbsuppliesltd5793 6 ай бұрын

That is AMAZING! Thank you! Aw HAAAA moment :)

@ExcelMoments 6 ай бұрын

Thanks for the feedback

@nagarajanvn7655 2 жыл бұрын

Excellent.. keep doing Don't stop

@ExcelMoments 2 жыл бұрын

Thank you very much for the feedback

@mostafaghorbani1910 2 жыл бұрын

Helo Thanks for video how i can a Drop Down List with hyperlink?

@ExcelMoments 2 жыл бұрын

Hello Mostafa. The drop down would not show hyperlinks, but whatever you select would become a hyperlink in the cell. You could provide more information, that may be helpful but you could also check out kzfaq.info/get/bejne/grqHqdh6vLPGmJc.html by Alan Murray,

@abdulhamidalhaddadi2255 Жыл бұрын

Thank you sir. I guess its working in local drive, but not working in share folder.

@ExcelMoments Жыл бұрын

I would have to test that to see.

@abdulhamidalhaddadi2255 Жыл бұрын

@@ExcelMoments Great, I am waiting your reply. Thank you

@Gambit135 5 ай бұрын

@@abdulhamidalhaddadi2255 Open File Explorer and go to folder with subfolder path you would like to copy. Select all the folders whose path you want to copy, go to home and select copy path. Then paste in a word or excel document.