I see, thanks Cindy. Do you have an example of macro code I could use to do
what you said - force 'save as', or automatically 'save as' on closing/save??
Thank you, Mel
"Cindy M." wrote:
Hi ?B?TWVsdGFk?=,
I have a word document with an excel document linked as an icon (and a table
of linked data from the spreadsheet paste special-ed below the icon in the
word doc).
Users need to save a local copy of the word document for each project they
undertake (master is stored on the intranet) - they then click into the
spreadsheet from the word doc and save this as part of their project - this
has recently started to save over the master copy. Changes made to the master
copy overwrite all individual project documents. I'm sure this never used to
happen!
If it's a link, I'm sure this always did happen. Links aren't just one way... If
the user double-clicks a linked Excel object this will open the workbook. The
users must use File/Save As to save a separate copy.
Possibly, something has changed in the folder permissions? If the Excel workbook
is saved in a read-only folder, the user would be forced to "Save As"? Or
perhaps there should be a macro in the workbook to automatically "save as" to a
different location when the user executes the Save command?
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)