vsmathur380052

========================================================================

CA Vikram S Mathur
(vsmathur380052)

========================================================================

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

CAclubindia : Experts : Expert Profile
... DISA), a course run by The Institute of Chartered Accountants of India, (ICAI), Delhi. The sole proprietorship firm is registered with the Institute of Chartered Accountants of India. Full Name:----- CA
http://www.caclubindia.com/experts/experts_profile.asp?member_id=28059

CA Vikram S. Mathur Profile - CA club india
... a course run by The Institute of Chartered Accountants of India, (ICAI), Delhi. The sole proprietorship firm is registered with the Institute of Chartered Accountants of India
\http://www.caclubindia.com/profile.asp?member_id=28059

Accounting & Bookkeeping - Hotfrog INDIA
... Website of an Indian Chartered Accountant residing in Ahmedabad, Gujarat, India. ... Basically into the practice of Accounting, Auditing, Income-Tax Return Filing,
http://www.hotfrog.in/find/Accounting-Bookkeeping

Accounting Services in Ahmedabad
... Website of an Indian Chartered Accountant residing in Ahmedabad, Gujarat, India. ... Basically into the practice of Accounting, Auditing, Income-Tax Return Filing,
http://www.hotfrog.in/find/Accounting-Services/Gujarat/Ahmedabad

VBA Macros: Create Hyperlink for filenames or folder names fro...

Source URL:VBA Macros: Create Hyperlink for filenames or folder names fro...:

---

Here is a easy way to solve my problem.

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")
 
  Const SheetToPutLinksOn = "Sheet1"
  Const ColumnWithFileNames = "A"
  Const firstFilenameRow = 1

  ThisWorkbook.Worksheets(SheetToPutLinksOn).Activate
  Application.ScreenUpdating = True
  partialPath = Path & "\"
  lastRow = Range(ColumnWithFileNames & Rows.Count).End(xlUp).Row - _
   firstFilenameRow
  Range(ColumnWithFileNames & firstFilenameRow).Select
  Application.ScreenUpdating = True
  For rOffset = 0 To lastRow
     If Not IsEmpty(ActiveCell.Offset(rOffset, 0)) Then
      linkPath = partialPath & ActiveCell.Offset(rOffset, 0).Text
      ActiveSheet.Hyperlinks.Add anchor:=ActiveCell.Offset(rOffset, 0), _
       Address:=linkPath
    End If
  Next
  ThisWorkbook.Saved = True
  Application.ScreenUpdating = True

End Sub
****************************************************************