![]() |
![]() |
![]() |
|||||
![]() |
![]() |
![]() |
![]() |
![]() |
|||
| Welcome
to Tech Support Forum home to more then 136,000 problems solved. Issues
have included: Spyware, Malware, Virus Issues, Windows, Microsoft,
Linux, Networking, Security, Hardware, and Gaming Getting your
problem solved is as easy as: 1. Registering for a free account 2. Asking your question 3. Receiving an answer Registered members: * See fewer ads. * And much more..
|
| Want to know how to post a question? click here | Having problems with spyware and pop-ups? First Steps |
|
|||||||
| Microsoft Office support MS Office support forum |
![]() |
|
|
LinkBack | Thread Tools |
|
|
#1 (permalink) |
|
Registered User
Join Date: Oct 2008
Location: Romania
Posts: 45
OS: Win XP SP3
|
Word - Macro that updates TOC & is triggered by file close
I wanted to have my documents' TOC updated everytime I save them, and therefore I added the following two macros into Normal.dotm:
Sub FileSave() ActiveDocument.TablesOfContents(1).Update ActiveDocument.Save End Sub Sub FileSaveAs() Dialogs(wdDialogFileSaveAs).Show ActiveDocument.TablesOfContents(1).Update ActiveDocument.Save End Sub However, when I save a document as a result of pressing Yes in a file close dialog ("Do you want to save the changes to...?"), the TOC does not update. I have therefore found out the code of the FileClose macro and created a new macro in Normal.dotm with the same and with the same code plus the ActiveDocument.TablesOfContents(1).Update line that updates the TOC. I now therefore have a FileClose macro that looks like this: Sub FileClose() ActiveDocument.TablesOfContents(1).Update If Not ActiveDocument.Saved Then Select Case MsgBox("Do you want to save the changes to " _ & Chr(34) + ActiveDocument.Name + Chr(34) & "?", _ vbExclamation + vbYesNoCancel, "Microsoft Office Word") Case vbYes FileSave Case vbNo ActiveDocument.Close wdDoNotSaveChanges Case vbCancel 'Do Nothing End Select Else ActiveDocument.Close wdDoNotSaveChanges End If End Sub However, documents saved from the file close dialog still not have their TOCs updated. Have I got anything wrong here? Thanks for any help! Last edited by longtalker; 11-23-2008 at 09:11 AM. |
|
|
|
| Important Information |
|
Join the #1 Tech Support Forum Today - It's Totally Free!
TechSupportForum.com is a leading support website for your computer needs. We offer free, friendly and personalized computer support. Why pay to have your computer fixed when you can do it for free. Join TechSupportforum.com Today - Click Here |
|
|
#2 (permalink) |
|
Registered User
Join Date: May 2008
Location: Baltimore, Maryland
Posts: 160
OS: Windows XP SP3
|
Re: Word - Macro that updates TOC & is triggered by file close
One way to make code run when a Word document is closed is to place the code in the ThisDocument class module of the document, using an event procedure for the Close event.
Code:
Private Sub Document_Close()
'Code to run
End Sub
Last edited by David M58; 11-23-2008 at 05:18 PM. |
|
|
|
![]() |
| Thread Tools | |
|
|