![]() |
#2
|
||||
|
||||
![]()
Hi KJJ,
Much of your code isn't related to the task you've described, so I've omitted it from the code below. Also, instead of using an 'Document_Close' macro, I've used a 'AutoClose' macro, which you place in the template's 'ThisDocument' module. The code below provides the prompts you're after, and only updates the properties if anything's changed. That way, the document doesn't give unnecessary 'save' prompts (though if you do include your other code for updating fields, you're going to get 'save' prompts anyway). Code:
Private Sub Document_Close() Dim StrOldTitle As String, StrNewTitle As String Dim StrOldAuthor As String, StrNewAuthor As String Dim StrOldSubject As String, StrNewSubject As String Dim bSaved As Boolean With ActiveDocument bSaved = .Saved StrOldTitle = .BuiltInDocumentProperties("Title").Value StrOldAuthor = .BuiltInDocumentProperties("Author").Value StrOldSubject = .BuiltInDocumentProperties("Subject").Value StrNewTitle = InputBox("Enter the Document Title:", "Title", StrOldTitle) StrNewAuthor = InputBox("Enter the Document Author:", "Author", StrOldAuthor) StrNewSubject = InputBox("Enter the Client and Site Name:", "Subject", StrOldSubject) If StrOldTitle <> StrNewTitle Then _ .BuiltInDocumentProperties("Title").Value = StrNewTitle If StrOldAuthor <> StrOldAuthor Then _ .BuiltInDocumentProperties("Author").Value = StrNewAuthor If StrOldSubject <> StrOldSubject Then _ .BuiltInDocumentProperties("Subject").Value = StrNewSubject If bSaved = True And .Saved = True Then Exit Sub End With End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Disable email security prompt | mcinnes01 | Outlook | 1 | 03-17-2011 07:00 AM |
Selecting the macro document | lars | Word VBA | 0 | 08-19-2010 06:06 AM |
Macro to put content into keywords properties? | erik2000 | Word VBA | 3 | 03-05-2010 10:14 PM |
Macro to export document sections to individual txt files? | MJMR999 | Excel Programming | 0 | 02-18-2010 12:49 PM |
document properties issues | charris1980 | Word | 0 | 04-29-2009 12:49 PM |