I frequently send, via e-mail, Personal.XLS files to multiple users on
network, thus enabling each of them to run various macros. The XLSTAR
folder is 4 or 5 levels down in the path for each user to store thei
file.

There are two issues:
- because each time a Workbook is opened, Personal.XLS is opened a
well, thus creating a conflict if the e-mailed file has the same name
and
- I wish to simplify the process for each user to store the new fil
in the appropriate location.

I did create a macro in my Personal.XLS, activated by keying 'Ctrl+s
that saves the file in the appropriate location. So, I guess m
question is how to automate the deletion of the "old" copy o
Personal.XLS for each user?

Any ideas?
Thanks for a response,
Chuckles12

--
Chuckles12
-----------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494
View this thread: http://www.excelforum.com/showthread.php?threadid=26591