Sounds like a bad approach. What if they have recorded macros in their
personal.xls that they want to keep.

any file open in Excel can hold macros and run them. There is nothing
particularly special about personal.xls except that excel recognizes it if
it is in the xlstart directory. any other workbook that has been hidden,
then saved in the xlstart directory will behave similar to personal.xls for
purposes of storing/running macros. So rename you workbook.

--
Regards,
Tom Ogilvy

"Chuckles123" wrote in message
...

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

There are two issues:
- because each time a Workbook is opened, Personal.XLS is opened as
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 file
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 my
question is how to automate the deletion of the "old" copy of
Personal.XLS for each user?

Any ideas?
Thanks for a response,
Chuckles123


--
Chuckles123
------------------------------------------------------------------------
Chuckles123's Profile:
http://www.excelforum.com/member.php...o&userid=14948
View this thread: http://www.excelforum.com/showthread...hreadid=265915