delete file with any type of extension.

[pakilprogramador]

please how do you can delete files from a folder with any extension, with macros.?

thanks.

 

[Smallman]

Hi pakilpropgramador

Give the following a try.

Sub GetRid()
    Kill "C:\Users\HYMC\Downloads\Test\*.*"
End Sub

Remember the \ at the end of the path.

Take care

Smallman

 

[Deepak]

please how do you can delete files from a folder with any extension, with macros.?

thanks.

Why not simply delete the folder & create a new one with the same name.

 

[pakilprogramador]

hi, deepak,

because, that folder contains thousands of important files with different extension.

so, for example thanks,

 

[Smallman]

So Pakilprogramador

Did you apply my suggestion? I figure applying my code is simpler than:

1. Finding the appropriate file
2. Deleting the whole fiolder
3. Creating a new file
4. Renaming the new file

The code should run perfectly on any file type.

Take care

Smallman

 

[pakilprogramador]

Private Sub eliminararchivos_Click()
  On Error Resume Next
    Kill "C:\reportes\*.xlsm"
    MsgBox "se elimino el achivo correctamente", vbInformation
    On Error GoTo 0
    End Sub

very well @Smallman thanks so much

regards,

 

[Smallman]

Well done

I could not have put it better myself even if I had written an article on this subject.

OhDear


Take it easy

Smallman

 

[pakilprogramador]

thanks @Smallman very good your web page ..