Unable to delete Sharepoint Excel file using Kill Command

[alibini]

Hi, and sorry for the basic question.

I am trying to delete a file in a sharepoint folder.

VBA.Kill ActieveWorkbook.Parth & "/*TEMP*.*"

continues to return the error:

Run-time error '53'. File not found.

The files is 100% there so don't understand why it doesn't find it.

If I replace *TEMP*.* with the exact filename and correct extension i get the same error message.

Any help much appreciated.

 

[Cubist]

It looks like a typo.

VBA.Kill ActieveWorkbook.Path & "/*TEMP*.*"

 

[alibini]

Sorry Cubist, was a typo above but not in my actual code so that's not the issue.
VBA.Kill ActieveWorkbook.Path & "/*TEMP*.*" produces the same error.

 

[JEC]

have you “synced” the sharepoint folder?

Run this and see what happens. This should return the https path, which will not be accepted by "kill"

debug.print activeworkbook.path

 

[alibini]

have you “synced” the sharepoint folder?

Run this and see what happens. This should return the https path, which will not be accepted by "kill"

debug.print activeworkbook.path

I would say NO. I'm not sure what that means or how to do it.

 

[alibini]

I would say NO. I'm not sure what that means or how to do it.

correct. it returns the https filepath.

if i try to kill using the filepath in the file explorer address eg "C:\Folder\Next Folder etc\filename.xlsm" it still gives me the same error

 

[JEC]

But can you find the file in a directory in your explorer? If so, do you have all rights in that folder?

Run this, select your file and see which filepath is being returned

Sub jec()
 With Application.FileDialog(msoFileDialogFilePicker)
   If .Show Then Debug.Print .SelectedItems(1)
 End With
End Sub

 

[alibini]

But can you find the file in a directory in your explorer? If so, do you have all rights in that folder?

Run this, select your file and see which filepath is being returned

Sub jec()
 With Application.FileDialog(msoFileDialogFilePicker)
   If .Show Then Debug.Print .SelectedItems(1)
 End With
End Sub

i just discovered the C:\ file path did in fact delete the file. but the folder had not refreshed. when i manually refreshed the folder it was gone. i feel a bit silly now

 

[alibini]

i just discovered the C:\ file path did in fact delete the file. but the folder had not refreshed. when i manually refreshed the folder it was gone. i feel a bit silly now

i mean the file was gone

 

[JEC]

Ok, so solved ;P