In Excel, How can I produce a carbon copy when saving?
 

I have a workbook that upon saving, i wish for it to produce a carbon copy on
a shared drive for public viewing, but keep the original secure. And each
time I update the original, the version on the shared drive will be
overwritten.

I'm not sure of the best method to go about this, if it is possible, or if a
macro can be made. I am pretty good in excel, but have little experience in
creating macros.

Help!

(i'm using Microsoft Office 2000)

In Excel, How can I produce a carbon copy when saving?
 

There may be a better / different way than this one, but here's what I've
done in the past:
original save as new book ( for others ) ( this will have the same
format already in there)

in cell A1 of that new book :
=IF([Book1]Sheet1!A1<"",[Book1]Sheet1!A1,"")
autofill into ALL cells where necessary, and maybe some extra.
this will create a link to the original and update as you change it.


"Lukas" wrote:

I have a workbook that upon saving, i wish for it to produce a carbon copy on
a shared drive for public viewing, but keep the original secure. And each
time I update the original, the version on the shared drive will be
overwritten.

I'm not sure of the best method to go about this, if it is possible, or if a
macro can be made. I am pretty good in excel, but have little experience in
creating macros.

Help!

(i'm using Microsoft Office 2000)

In Excel, How can I produce a carbon copy when saving?
 

Hi Lukas,
See http://www.mvps.org/dmcritchie/excel/backup.htm#demand
the second macro is an Event macro
http://www.mvps.org/dmcritchie/excel/event.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Lukas" wrote in message ...
I have a workbook that upon saving, i wish for it to produce a carbon copy on
a shared drive for public viewing, but keep the original secure. And each
time I update the original, the version on the shared drive will be
overwritten.

I'm not sure of the best method to go about this, if it is possible, or if a
macro can be made. I am pretty good in excel, but have little experience in
creating macros.

Help!

(i'm using Microsoft Office 2000)