killing an open file

[sassriverrat]

I have a workbook that recognizes (through the registry) the first time it's been opened, generates its own folders and directories during that first time being opened, and a number of other things. I'd like a macro that basically will allow the user to drag to receive the workbook via email (for the first time), save it on their computer, open it, allow it to go through the first time being opened and added in the registry, and then when it generates its directory/save folders, it will save itself under the same name in the new folder and then delete the previous copy (the imported). All of the save portions are fairly easy for me. I'm not sure, however, how to kill the original file without specifying an address like "kill "C:\blah\blah" I want it to be dynamic so if the user saves the first time file into downloads, it'll delete that file, and if another user saves it for the first time on the desktop, it'll delete from desktop. Make sense? Thanks

 

[JLGWhiz]

I don't have a solution, but I wonder about the security of the recipient even allowing the file to open on their system. That would probably have to be part of the file certification.

 

[sassriverrat]

bump