Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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) |
#2
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is my copy of Excel corrupt? | Excel Discussion (Misc queries) | |||
How copy Excel macros from Excel XP (or before) to Excel 2003? | Excel Worksheet Functions | |||
Copy and Paste from Excel to powerpoint the pix is Truncated | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
Saving excel backup copy - path? | Excel Discussion (Misc queries) |