Get a macro to delete it's file when closed

[Saa62]

I know this may sound strange, but I want to be able to delete the file after the macro has been run. Part of the macro makes a copy of the file into another folder. The original file needs to be deleted after the file has been copied. Is this possible?

Thanks

Scott

 

[Saa62]

I got the second routine in this thread to work. The first one I had problems with the Kill command. It may have been something I was doing wrong. Anyway I have one more desire to complete this routine. Is it possible to get excel to close when it is all finished. I tried Quit.Application in a couple of different places but without success. Any suggestions?

PS I guess I can live with everyone at work thinking I am a genious, I will just have to be carefull not to let it go to my head.

Thanks

Scott