VBA code to open a sharepoint file directly in Desktop app

[kgkev]

I would like to add a sharepoint file to my tool bar so i can open it directly from the desktop app.

I know the file location in share point, but when adding this to the code It appears to open but I am left with just a blank page with title "fhsdjfhsd"

this is the code I have used...doctored slightly for security.

Private Sub Production_Open()
Application.ScreenUpdating = False

Application.AskToUpdateLinks = False
    Workbooks.Open filename:= _
    "https://my.sharepoint.com/:x:/s/CriticalDateandCapacityPlanning/fhsdjfhsdjfhsd", _
    UpdateLinks:=0
End If

Application.ScreenUpdating = True
End Sub

is it possible?

 

[6StringJazzer]

I appreciate the need for privacy but is the filename fhsdjfhsd or is it more like fhsdjfhsd.xlsx?

 

[kgkev]

I appreciate the need for privacy but is the filename fhsdjfhsd or is it more like fhsdjfhsd.xlsx?

There is no file extension on the share point link. It's juts a series of letters

If I click the link it opens in the browser perfectly. But not when opening from vba.

 

[6StringJazzer]

I have used SharePoint and have never seen that. Is the thing you are clicking on a SharePoint link (like a Windows shortcut) that refers to a file that is in a different physical location? I don't think VBA file references will resolve a shortcut link.