deleting a file programmatically

[Klaus Iden]

I need to delete a temporary workbook after I'm finished
with it and can't remember how to do it.
Help!

 

[Jan Karel Pieterse]

Hi Klaus,

I need to delete a temporary workbook after I'm finished
with it and can't remember how to do it.

If it is a file:

Kill "c:\whateverPath\WhateverWorkbook.xls"

Otherwise:

Workbooks("WhateverWorkbook.xls").Close SaveChanges:=False

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[Tom Ogilvy]

If you never saved it:

ActiveWorkbook.Close SaveChanges:=False

 

[Harald Staff]

Hi

Kill ("C:\Temp\Wbk.xls")

HTH. Best wishes Harald

 

[Klaus Iden]

Thanks!!!!!!