Kill line not working

[Billy C]

Hi,
Can anyone tell me why the kill line is not working in this code?
the error is runtime error 53
file not found

MyPath = ActiveWorkbook.Path
ActiveWorkbook.SaveAs Filename:=MyPath & MyName
ActiveWorkbook.SendMail Recipients:="billy.cameron@networkrail.co.uk", Subject:="TS Submittal " & trimName
ActiveWorkbook.Close
Kill "MyName.xls"

 

[Richard Schollar]

Is the file actually called "MyName.xls" or is MyName simply the variable that holds the name of the file?

If it isn't called "MyName.xls" it won't work.

Regards

Richard

 

[goblin]

If MyPath = c:\temp, you are saving your file as c:\tempMyName.xls

First, you need to add a backslash between the path and the name.

Second, you need to kill the file with a full path:

MyPath = ActiveWorkbook.Path 
ActiveWorkbook.SaveAs Filename:=MyPath & "\" & MyName 
ActiveWorkbook.SendMail Recipients:="billy.cameron@networkrail.co.uk", Subject:="TS Submittal " & trimName 
ActiveWorkbook.Close 
Kill MyPath & "\" & MyName