Here's my current issue, hopefully someone has some advice on this solution:


Basically, I have an excel doc saved somewhere on a networked drive. What I want, is if someone goes to that excel doc, clicks a button, it would save that excel doc to another location (i can do this already), and delete the old excel doc from the previous location.

I'm not sure how I would go about automating the delete process of the old excel doc. I can run a batch file, but a couple of problems arise there;
1) What if there are more than one excel docs in the folder. The batch file needs to know which one to delete.
2) How can an excel doc run a batch file if its already closed.

Not sure if there are answers to these other than it can't be done.

Any help would be appreciated. Thanks.