My code opens another file on Onedrive, do stuff and save it.
It is something like this:
Code:
Dim xl0 As New Excel.Application
Dim xlw As New Excel.Workbook
Set xlw = xl0.Workbooks.Open("https://d.docs.live.net/679d4848dd/Something.xlsx")
'DO STUFF
xlw.Save
xlw.Close
Set xl0 = Nothing
Set xlw = Nothing
BUT I dont want to try to open the file if file is currently in use.
All solutions I have found so far works for local files, not for https. (they give bad file name or type mismatch errors)
Any suggestions?
It is something like this:
Code:
Dim xl0 As New Excel.Application
Dim xlw As New Excel.Workbook
Set xlw = xl0.Workbooks.Open("https://d.docs.live.net/679d4848dd/Something.xlsx")
'DO STUFF
xlw.Save
xlw.Close
Set xl0 = Nothing
Set xlw = Nothing
BUT I dont want to try to open the file if file is currently in use.
All solutions I have found so far works for local files, not for https. (they give bad file name or type mismatch errors)
Any suggestions?