I am looking for a solution how to delete my files in a depository at once. I made a list in excel (column A) with files with their full names, which I want to delete from this depository:
My files for deleting are in various forms (pdf, word, zip, doc) and have various names.
Until now I could find makro, vba in Excel only for deleting 1. all files from the depository, 2.files with a specific format 3. a specific file. Non of these solutions are appropriate for me.
One solustion was supposed to be suitable, but it does not work:
Dim i As Long
For i = 1 To Range("A" & Rows.Count).End(xlUp).Row
Kill Cells(i, 1).Value
This makro has a problem with the "Kill Cells(i, 1).Value". I would be thankfull if you could help.