List of Domains

Vikram Shankar Mathur

RESIDENCE:

B-404, Shashwat Apartments

Atithi Dining Hall Lane

B/h GNFC Infotower, Bodakdev

AHMEDABAD-380054

LIST OF DOMAINS

    Sr.No. Old Domain (2020)                        Current URL (2024)

1. www.vsmathurcoin.com                      vsmathurcoin.blogspot.com
2. www.vsmathur.co.in                            N.A.
3. www.vsmathur.in                                 N.A,
4. www.ahmedabadfca.org                      ahmedabadfca.blogspot.com
5. www.cavsmathur.net                           cavsmathur.blogspot.com
6. www.cavsmathurin.com                      cavsmathurin.blogspot.com
7. www.cavsmathur.co.in                        N.A.
8. www.ktvayedaco.com                         ktvayedaco.blogspot.com
9. www.cavsmathur.co.in                        N.A.
10. www.exceltrainerahmedabad.com      exceltrainerahmedabad.blogspot.com
11. www.vsmathur.org                              N.A.
12. www.deadlyvbaprogrammer.com       deadlyvbaprogrammer.blogspot.com
13. www.vsm1962.com                             N.A.
14. www.vbacoder1962.com                     vbacoder1962.blogspot.com
15. www.vbabeginner.com                        vbabeginner.blogspot.com
16. blog.vsmathurcoin.com                       vikramshankarmathur.blogspot.com
17. shop.vsmathurcoin.com                       vsmathurcoinshop.blogspot.com
18. blog.exceltrainerahmedabad.com        vsmathur380052.blogspot.com
19. vsm.exceltrainerahmedabad.com         vikramsmathur.blogspot.com
20. vsmathur.exceltrainerahmedabad.com vsmathur380054.blogspot.com
21. disa.exceltrainerahmedabad.com         N.A.
22. blog.cavsmathurin.com                        N.A.

    Last Updated on 13-October-2024 @ 02:34:23 Hours IST
    CA Vikram Shankar Mathur
    9998090111 / 8460890111

Extreme Markup Editor for Blogger™: Syntax and Features

Extreme Markup Editor for Blogger™: Syntax and Features: If you are familiar with other markup languages like Markdown , understanding Extreme Markup is fairly easy. Like other text markup lang...

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

Wow, this is really something that I could use, as a programmer myself !! :-) :-)


CA Vikram S Mathur
vsmathur380052@gmail.com

Created  : 08-Sep-2019 | 23:15 Hours IST | vsmathur380052@gmail.com
Modified: 18-Oct-2019 | 09:10 Hours IST | vikramsmathur@gmail.com

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
****************************************************************