View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hello Hello is offline
external usenet poster
 
Posts: 6
Default How can delete file by Marco

Hi,

I have problem to delete files, because I only want to delete some
file the name have / include the words of "test" on file name, and I
don't know the path in my local drive (C:). How can I do?

Here is my code for specific path, but how can I change the code for
delete if the file name have / include the words of "test" under my
local drive (C:). Thanks~

On Error Resume Next
Kill "C:\Users\*test*.xl*"
On Error GoTo 0