Code to delete an Excel File
 

I must be missing something but I am having trouble trying to write a macro
to delete and Excel file. I have tried the following but does not work......
Application.Workbooks("N:\MaintCo-ord\Mech\Maint Day Roster for
Viewing.xls").Delete
Can anyone point me in the right direction.

Thanks
Ray

Code to delete an Excel File
 

Ray,
The VB VBA command is KILL.

Kill "N:\MaintCo-ord\Mech\Maint Day Roster for Viewing.xls"

John

"Ray Clark" wrote in message
...
I must be missing something but I am having trouble trying to write a macro
to delete and Excel file. I have tried the following but does not
work......
Application.Workbooks("N:\MaintCo-ord\Mech\Maint Day Roster for
Viewing.xls").Delete
Can anyone point me in the right direction.

Thanks
Ray

Code to delete an Excel File
 

John,

Thank you this was a great help as had not picked this up before. Much
appreciated.
Ray

"jaf" wrote:

Ray,
The VB VBA command is KILL.

Kill "N:\MaintCo-ord\Mech\Maint Day Roster for Viewing.xls"

John

"Ray Clark" wrote in message
...
I must be missing something but I am having trouble trying to write a macro
to delete and Excel file. I have tried the following but does not
work......
Application.Workbooks("N:\MaintCo-ord\Mech\Maint Day Roster for
Viewing.xls").Delete
Can anyone point me in the right direction.

Thanks
Ray