title: Macro to open a excel in shared path
body: <p>Hi all i am able to open any excel files in my desktop. but i am not able to open a excel which is in shared path. file not found error message is displayed
  Need your help...!!!
  The path starts with two backslashes "\..\.....\"</p>
  
  <pre><code>Sub open_hari()
      Dim r As Long
      For r = 1 To 10
          If Cells(r, 1).Value &lt;&gt; "" Then
              Workbooks.Open Filename:=Sheet1.Cells(r, 1).Value
          End If
      Next r
  End Sub
  </code></pre>