VBA code to delete file in a folder

[shafiq2]

Hi,

I am looking for a VBA code to delete all file in a folder if file name starts with "Reptxxxxxx"

The file from left 4 characters always starts with Rept

Best Regards,
Shafiq

 

[Villalobos]

Hi shafiq2,

Try this:

 Sub DeleteSpecificFile()
Kill "C:\Documents\Rept*"
End Sub

 

[shafiq2]

Hi Villalobos,

Thanks for the code but it is not working, says the file is not found.

Best Regards,
Shafiq

 

[Villalobos]

What is path of files what you want to delete?

 

[shafiq2]

Hi Villalobos,

It is is working perfectly. Thanks for the help.

Best Regards,
Shafiq

 

[Villalobos]

Glad I could help.

 

[Sanjeev06]

Sub delete()

Dim i As String
i = "D:\Roung\rept*"
Kill i


End Sub