Hi Microsoft,

I would like to be able to automatically save shared excel files (read only
back up) to a different location so that other users can read the file,
without having to give them access to a certain network drive.

I know it is possible to create an automatic back up (I already use this
feature for recovery purposes), but I would like the file to save itself in a
different location as well. This is not a new question, as you can see from
the below (helpful) entries on answers.google.com. I would really appreciate
an answer as to whether MS will provide a solution to this not so strange
request.

http://answers.google.com/answers/th...id/123071.html

Thanks in advance


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Please set up your macro to do this for you. Microsoft is not likely to
consider this as a "value adding feature" as 1. there is not much call
for it and 2. you can do it yourself.

geezz wrote:
Hi Microsoft,

I would like to be able to automatically save shared excel files (read only
back up) to a different location so that other users can read the file,
without having to give them access to a certain network drive.

I know it is possible to create an automatic back up (I already use this
feature for recovery purposes), but I would like the file to save itself in a
different location as well. This is not a new question, as you can see from
the below (helpful) entries on answers.google.com. I would really appreciate
an answer as to whether MS will provide a solution to this not so strange
request.

http://answers.google.com/answers/th...id/123071.html

Thanks in advance


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Microsoft won't do this, because it doesn't involve fancy visual effects.
However, my colleague Jan Karel Pieterse has a utility which is much better
than Excel's built-in autosave. Look for the AutoSafe utility:

http://jkp-ads.com

In addition, you could use the Workbook.SaveCopyAs command to do something
yourself.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"geezz" wrote in message
...
Hi Microsoft,

I would like to be able to automatically save shared excel files (read
only
back up) to a different location so that other users can read the file,
without having to give them access to a certain network drive.

I know it is possible to create an automatic back up (I already use this
feature for recovery purposes), but I would like the file to save itself
in a
different location as well. This is not a new question, as you can see
from
the below (helpful) entries on answers.google.com. I would really
appreciate
an answer as to whether MS will provide a solution to this not so strange
request.

http://answers.google.com/answers/th...id/123071.html

Thanks in advance


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc