Using Kill and "*.*" to delete all files in a folder

[cfdh_edmundo]

Hi,

I have a line of code as follows:

Kill tempPath & "*.*"

which works exactly as I want. I deletes all files in a temporary folder before running the rest of the macro.

The problem I have is when there are no files in the directory (i.e. it's an empty directory) then I get a "Run-time error '53': File not found" error.

Is there a neat way to put some simple error handling so the macro will just skip the line if there directory is empty?

Many thanks for any help,

Chris

 

[Domenic]

Try...

On Error Resume Next
Kill tempPath & "*.*"
On Error GoTo 0

Hope this helps!

 

[cfdh_edmundo]

Works great, thanks very much!