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:
* Get free support
* Communicate privately with other members (PM).
* Removal of this message
* 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
Go Back   Tech Support Forum > Microsoft Support > Microsoft Office support
User Name
Password
Site Map Register Donate Rules Blogs Mark Forums Read


Microsoft Office support MS Office support forum

Reply
 
LinkBack Thread Tools
Old 11-23-2008, 09:09 AM   #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.
longtalker is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit!
Reply With Quote
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

Old 11-23-2008, 05:15 PM   #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.
David M58 is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit!
Reply With Quote
Reply


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




All times are GMT -7. The time now is 10:40 PM.



Copyright 2001 - 2009, Tech Support Forum
Home Tips Plus | Outdoor Basecamp | Automotive Support Forum

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85