Thread: Windows 7 keeps closing Excel during macro debugging

It's hard to say without seeing what you are doing

Hi there sorry I got a bit distracted with work...
I am using this function (got it from somewhere) to resolve the network path which may be compromising the rest of the file (I don't have previous experience with this one):

   Declare Function WNetGetConnection32 Lib "MPR.DLL" Alias "WNetGetConnectionA" (ByVal lpszLocalName As String, ByVal lpszRemoteName As String, lSize As Long) As Long

and using it in a function later on in the macro:

   Function GetNetPath(DriveLetter As String)
      cbRemoteName = lBUFFER_SIZE ' Specifies the size in characters of the buffer.
      lpszRemoteName = lpszRemoteName & Space(lBUFFER_SIZE) ' Prepare a string variable by padding spaces.
      lStatus& = WNetGetConnection32(DriveLetter, lpszRemoteName, cbRemoteName) ' Return the UNC path (\\Server\Share).
      
      ' Verify that the WNetGetConnection() succeeded. WNetGetConnection()
      ' returns 0 (NO_ERROR) if it successfully retrieves the UNC path.
      If lStatus& = 0 Then
         iChar = InStr(lpszRemoteName, Chr(0))
         GetNetPath = Left(lpszRemoteName, iChar - 1) ' Display the UNC path.
      Else
         GetNetPath = "" ' Unable to obtain the UNC path.
      End If

   End Function

My aim is to automatically put correct hyperlinks in the sheet to other excel files on our network (i.e. this file would be like a summary/directory from which to access the other files). I have another function which then retrieves some values from these other excel files but it seems to be crashing before then.