Is the code in the workbook "Collection Note.xls" ?

If so, once you close it (which you do in the second line) the code stops
executing.

--
Regards,
Tom Ogilvy

"JamieD " wrote in message
...
Hi all,
Very quick one for you,
Any body able to tell me why the below doesn't work. If I run the Kill
line by itself then its fine.

Windows("Collection Note.xls").Activate
ActiveWindow.Close
Kill "G:\EXCELDOC\Returns Check\Collection Note.xls"

Hope someone can help/

Many Thanks

J


---
Message posted from http://www.ExcelForum.com/