I am having trouble deleting a workbook via VBA, the workbook is stored on a SharePoint, so the file location is a URL. Here an example of the code I have now:

Dim OldFile As String
OldFile = "http://sharepoint.server.com/Documents/Workbook.xlsm"

Kill OldFile
The error I get is "Run-time error '53': File not found". However I have access to the file, and I do have permission to delete it.

Any ideas or workarounds for this?

I technically do not need to delete the file, I really need to move it to another location, however, I don't believe there is any other way to accomplish this unless you delete the file and save it as a new one in the new location.

Thank you in advanced!