Sending Personal.xls Files To Multiple Users

[Chuckles123]

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

 

[Tom Ogilvy]

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.

 

[Gord Dibben]

If on a network, you should be able to store the macros in an
Add-in(MyMacros.xla) which would be available in one folder on the network for
all users to point at through Tools>Add-ins.

No need to email to users, just make changes in the one file.

Leave their Personal.xls alone.

Gord Dibben Excel MVP

 

[Ken Wright]

If you did that to my personal.xls I would hunt you down and feed you to the
wolves (assuming I didn't have a backup that is, but you can bet I do :-> ). As
Tom said, just rename it.