VIKRAM SHANKAR MATHUR (52)
Chartered Accountant cum Developer from Ahmedabad, Gujarat, India.
Contact me at vsmathur380052(at)gmail(dot)com - Cheers !!
CA Vikram S. Mathur ... We are basically into the practice
of Accounting, Auditing, Income-Tax Return ... In May 1995, he began his practice as an Associate Chartered Accountant and
upgraded to Fellow Chartered Accountant in 2002. in March'2006 he also https://about.me/vsmathur
I create a hyper link in excel to only the specific sub folders which i have to check and open them by clicking the hyperlink.
Note: Please take care that the the list of folder names you want to
create hyperlink is present in "Sheet1" and in Column "A" or else you
can modify the code according to your need.
Provide the Main folder path in the Input Box when it pop ups.
For any assistance please post me.
Here is the code for hyperlinking.
****************************************************************
Code:
**************************************************************** Sub Create_Hyperlink()
Dim Path As String
Dim lastRow As Long
Dim rOffset As Long
Dim partialPath As String
Dim linkPath As String
Path = InputBox("Please paste the path to which the list should be hyperlinked")