Hyperlink all folder inside the main folder

Hi can someone help me I'm newbie here I want to make a vba code that will hyperlink only folder I have more than a thousand folder inside the main folder I want to hyperlink it all except all the extension like .pdf .exe etc.. inside the folder thanks in advance

Something like below (assuming Windows machine).

Please Login or Register  to view this content.

thanks a lot its working but I want if you choose a directory and you choose the folder that time it will hyperlink thanks again

... I want if you choose a directory and you choose the folder that time it will hyperlink thanks again

Not sure what you mean. Can you elaborate?

when you run the code it will pop up the directory and you will choose which drive you will use (ex. C:, D:, network drive: etc.. ) after that when you choose the drive, the folder in it will automatically hyperlink. thanks again for your help I appreciate it.

Something like below.

Please Login or Register  to view this content.

thank you very much your the star :D

Hi mate the code that you make had a run-time error 1004 application - defined or object-defined error in excel 2016

Can you tell me which line is highlighted when you go into debug mode?

It runs without issue on my machine (Excel 2010 & 2016 on Windows 7, Excel 2013 on Windows 10).

Also, if using "C:\" you may need admin rights. Try changing it to folder of your choice.