Resolved: What if the file i want to delete has already been deleted ("kill" macro)?

[MickFlanagen]

I'm using the following macro:

Private Sub Workbook_BeforeClose(Cancel As Boolean)

Kill "T:\usequty\Audit Reporting\T-Cross Reports\tcross.xls"

End Sub

The marco is working well, but it is very possible that the file has already been deleted. In such cases, I do not want the error to come up. Is there a way to tell excel "if this file exists, delete it. If not, just close"?

Thanks for the help

Mick

 

[VoG]

Re: What if the file i want to delete has already been deleted ("kill" macro)?

Possibly

Private Sub Workbook_BeforeClose(Cancel As Boolean)

If Dir("T:\usequty\Audit Reporting\T-Cross Reports\tcross.xls") <> "" Then Kill "T:\usequty\Audit Reporting\T-Cross Reports\tcross.xls"

End Sub

 

[Trevor G]

Re: What if the file i want to delete has already been deleted ("kill" macro)?

This might work for you.

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> checkfile1()<br><SPAN style="color:#007F00">'Use the dir to check if the file exist in the folder</SPAN><br><SPAN style="color:#00007F">If</SPAN> Dir("T:\usequty\Audit Reporting\T-Cross Reports\tcross.xls") <> "" <SPAN style="color:#00007F">Then</SPAN><br>    Kill "T:\usequty\Audit Reporting\T-Cross Reports\tcross.xls"<br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN><br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN><br></FONT>

 

[MickFlanagen]

Re: What if the file i want to delete has already been deleted ("kill" macro)?

That seems to have fixed it, much appreciated

Mick