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

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

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 ToolsAdd-ins.

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

Leave their Personal.xls alone.

Gord Dibben Excel MVP

On Sun, 3 Oct 2004 15:06:13 -0500, Chuckles123
wrote:


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

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.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"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



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.771 / Virus Database: 518 - Release Date: 29/09/2004