Word 365 attached template from Onedrive shows URL instead of path

José Spanjaard  You can pick up the current user's local OneDrive folder path from the registry, using code like this:

Dim myWS As Object

Function RegValueExists(i_RegKey As String) As Boolean
  On Error GoTo ErrorHandler
  'try to read the registry value
  myWS.RegRead i_RegKey
  'value was found
  RegValueExists = True
  Exit Function
  
ErrorHandler:
  'key was not found
  RegValueExists = False
End Function

Function RegValueRead(i_RegKey As String) As String
  On Error Resume Next
  'read value from registry
  RegValueRead = myWS.RegRead(i_RegKey)
End Function

Sub testOneDrive()
    Dim strOneDriveKey As String
    Dim strOneDriveFolder As String
    
    strOneDriveKey = "HKEY_CURRENT_USER\Software\Microsoft\OneDrive\UserFolder"
    
    On Error Resume Next
    'access Windows scripting
    Set myWS = CreateObject("WScript.Shell")
    If myWS Is Nothing Then
        MsgBox "Could not access scripting shell"
        Exit Sub
    End If
    
    If RegValueExists(strOneDriveKey) Then
        strOneDriveFolder = RegValueRead(strOneDriveKey)
    End If
    
    If strOneDriveFolder <> "" Then
        MsgBox strOneDriveFolder, vbInformation, "OneDrive User Folder"
    Else
        MsgBox "Folder not found", vbExclamation, "OneDrive User Folder"
    End If
End Sub