I am having a excel workbook. When a person click on the marco the files are saves to two new folders need to delete a Excel file on SharePoint.
I have tried the "Kill" function in Excel VBA, but is says the file do not exist.
Sub DeleteExample3() 'You can use this to delete one xls file in the folder Test On Error Resume Next Kill "C:\Users\Ron\Test\ron.xls" On Error GoTo 0 End Sub
Do any one have success or a example by killing a file using VBA?!