Kill Command IF File Exists

[Trevor G]

I have a workbook which I have created from a transfer query from Access, if the file exists I want to delete it, I know that I can use the Kill command like this

Kill CurrentProject.Path & "\" & "DUA Export Binder And Lineslip.xls"

But I want to check to see if it exists first, if it does Kill it if not then the code will create it.

 

[VoG]

Try

If Dir(CurrentProject.Path & "\" & "DUA Export Binder And Lineslip.xls") <> "" Then Kill CurrentProject.Path & "\" & "DUA Export Binder And Lineslip.xls"

 

[Trevor G]

Thank you Peter,

I struggled on this kept getting my IFand Then and Dir <> mixed up.

Works well know.