startup macro to delete a file

[sahmiele]

I would like to create a macro that runs each time I open Excel. I have a file called "order entry setup" in the XLStart folder. I want it to look at the date it was created, and if the current date is more than one month later, I want it to delete itself. Is this possible and if so, how? I want to make sure that my remote users are continually updating this file. Thanks in advance.

 

[Chattin]

Haven't got your answer but a few suggestions.
To run a macro each time the file opens use the Workbook_Open event or Autpen

Check out

http://www.j-walk.com/ss/excel/tips/tip57.htm

to determine the file creation date

Have a look in the VBE help for the Kill Statement

Chris ;-)

Visit

http://www.mrexcel.com/board/index.php

for great xl and xl/VBA help

 

[sahmiele]

I understand how to use the kill statement. The only problem is that I need the macro to go into the file that is going to be deleted and the kill statement will not delete a file that is already open. Once I close the file down, the macro quits running. I somehow need to have the startup macro create a new file, put the kill statement in a macro on that file, run the macro in the other file, which would close the original file and then execute the kill statement. I don't know if this makes sense or if it is even possible. Any thoughts would be greatly appreciated.

 

[PHV]

Have you tried to save the workbook in a temporary location, hopefully this will close the launched one ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884