VBA Code to save picture file to SharePoint Location - need path vba code

[mriggle78]

I found the below code which saves a picture to my desktop but I would like to change the path so that it saves to a SharePoint drive location. Just wondering how you would write the path code for this differently as the path is typically an https:// file extension. Thanks for the help!

Sub CopyRangeToJpeg()
    Dim aChart As Chart, Rng As Range, Path As String
    Path = CreateObject("WScript.Shell").SpecialFolders("Desktop") & "\" & "Capture.jpg"
    Set Rng = Sheets("TABLE").Range("C2:G57")

    Call Rng.CopyPicture(xlScreen, xlPicture)
    With Sheets.Add
        .Shapes.AddChart
        .Activate
        .Shapes.Item(1).Select
        Set aChart = ActiveChart
        .Shapes.Item(1).Line.Visible = msoFalse
        .Shapes.Item(1).Width = Rng.Width
        .Shapes.Item(1).Height = Rng.Height
        aChart.Paste
        aChart.Export (Path)
        Application.DisplayAlerts = False
        .Delete
        Application.DisplayAlerts = True
    End With
    MsgBox "Saved to " & vbCr & Path, vbInformation, ""
End Sub

 

[Micron]

AFAIK all you need is the server path (UNC path). This is not the same as the url of the page or folder that it displays. It begins with \\ and then the server name, then the regular folder path structure.
If you can map a drive to it (using File Explorer, e.g. map "M:" ) the server path will be in the properties dialog box for the drive you map to it.