"locking" a document after saving it

[Bruce]

I use Word and Excel to create my invoices. What I need to do is, once the
document is saved, to NOT have it updated when ever I update excel and then
open the document again. I need to show the info as it was at the time
service was performed. How can I prevent the feilds from being refreshed?

Thanks
Bruce

 

[Doug Robbins - Word MVP]

Best thing to do is to convert the document to a .pdf file. Check out
PrimoPDF for a free converter.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Graham Mayor]

Break the link with Excel - CTRL+A then CTRL+SHIFT+F9
or by macro

Sub BreakLink()
Selection.WholeStory
Selection.Fields.Unlink
End Sub

You could incorporate this in the file save routine in your invoice template

Sub FileSave()
Selection.WholeStory
Selection.Fields.Unlink
ActiveDocument.Save
End Sub

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>