Deleting an Excel File

[Ray Clark]

I need to be able to write a macro to delete an Excel File and I have to be
missing something but nothing I try seems to work.
This is the last line of code I tried but........
Application.Workbooks("N:\MaintCo-ord\Mech\Maint Day Roster for
Viewing.xls").Delete

Hope someone can set me straight.

Thanks
Ray

 

[Bob Greenblatt]

I need to be able to write a macro to delete an Excel File and I have to be
missing something but nothing I try seems to work.
This is the last line of code I tried but........
Application.Workbooks("N:\MaintCo-ord\Mech\Maint Day Roster for
Viewing.xls").Delete

Hope someone can set me straight.

Thanks
Ray

If you really want to delete the file from the hard disk, use:
kill "n:\Maint.......

 

[Ray Clark]

Thanks Bob will give it a go.
Ray

If you really want to delete the file from the hard disk, use:
kill "n:\Maint.......