Deleting a file in SharePoint

[tasander]

Hello

I have a macro which pushes out the current excel workbook that I am in to various different SharePoint sites. I would like to be able to delete the previous version of the file. I have the name of the previous file stored in a variable called 'OldFileName'. I check that the file exists by seeing if it will open and it does so that isn't the issue.

I have tried the 2 different options but everytime I get the message "Run time error 53: File not found.

.DeleteFile OldFileName
kill OldFileName

Can anyone help? if this isn't possible then can I move these files into a different folder at least?

Many Thanks

 

[K e v i n]

kill should work - does 'OldFileName' have the full path?

 

[tasander]

Hi Kevin

Yes it does and I have checked it is correct by opening the file up.

Do I need to have any specific references enabled for this to work?

Thanks

 

[K e v i n]

Hi,

I misread your ask. I order to delete a file from within SharePoint you'll need to use the

lists.asmx web service 'http://your_server_name/_vti_bin/lists.asmx'. Is that one of the options you tried? - there is a good article at https://msdn.microsoft.com/en-us/li...aspx?cs-save-lang=1&cs-lang=vb#code-snippet-1​

 

[tasander]

I hadn't even realised that document repositories are actually also lists. I had a look at the link you sent me and am struggling to understand it plus vb doesn't seem to like the code that they offer even before i get to personalise it to my task.

 

[tasander]

I have actually found the answer via this link

excel vba - Deleting Sharepoint Files using XMLHTTP - Stack Overflow