Hallo, I am trying to check if the file is locked by another user. File is located online : "https://my.sharepoint.com/personal/jhofmann/documets/ForecastEurope.xlsx"
I checked with code like this
Function isworkBookOpen( Filenam as string)
Dim ff as long, errno as string
On error resume next...