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"
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"