Delete file, based on cell name

[tm0206]

Hi,
I am looking for a VBA to delete a files, with the name of the file coming from a cell value.

Cell A1 = names
I would like to delete the file "names" from c:\inventory\data

I am think of using, but not sure how to include the cell into the statement?
kill c:\inventory\data\"A1".xls

 

[rahulgoje]

Sorry, no... I have been retired and, hence, not had access to a network system, for some 16 years now. I would think if the path is set up correctly, it should work, but I have no way to test that. Does it maybe work if you map your network drive to a local hard disk letter and then use it for the path?

Another question if I need to delete only .pdf files in respective folder how can i write the code? As all files are deleting windows above code.
Thank you

 

[rahulgoje]

Great, this works perfectly for local files. Any idea why it wouldn't work for a network path?

Another question if I need to delete only .pdf files in respective folder how can i write the code? As all files are deleting if we use above code.
Thank you

Quote Reply

 

[rahulgoje]

Hi,
I am looking for a VBA to delete only some files, with the name of the file coming from a cell value. I am using below code but all files are deleting I need to delete only pdf files

[table="width: 500"]
[tr]
[td]Sub DeleteMultipleFiles()
Shell Environ("comspec") & " /c DEL /Q " & """" & Join(Application.Transpose(Range("A2", Cells(Rows.Count, "A").End(xlUp))), """ """) & """", vbHide
End Sub[/td]
[/tr]
[/table]