Open exlorer path from inside excel!!

hi Sirishgreen,

You can use the hyperlink function. See xl help.

=HYPERLINK("http://example.microsoft.com/report/budget report.xls", "Click for report")

in VBA Code you can try:

Private Sub Worksheet_Activate()
With Worksheets(1)
    .Hyperlinks.Add .Range("E5"), "http://example.microsoft.com"
End With
End Sub

Hi Sirishgreen,

You can use the hyperlink to open a folder or file.

In the worksheet, enter any file or folder name in a cell, then right click on that, then Select Hyperlink. You can browse where the file of folder is located then click Ok.

You can read more about Hyperlink in the excel help.