Duplicating and Updating Information

macropod · #4 05-11-2020, 03:53 PM

Quote:

Originally Posted by pooldead

Also, is there a way I can use VBA to auto-update when the document is opened, that way if there are any changes to the source document the user won't have to manually hit F9 to update?

You could, for example, insert the following macro into the 'ThisDocument' code module of the document or its template:

Code:

Private Sub Document_Open()
Application.ScreenUpdating = False
With ActiveDocument
  .Fields.Update
  .PrintPreview
  .ClosePrintPreview
End With

For PC macro installation & usage instructions, see: Installing Macros
For Mac macro installation & usage instructions, see: Word:mac - Install a Macro

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calendar Duplicating On It's Own	Nadine67	Project	0	12-06-2017 01:33 PM
Help duplicating text box	tabbakh	Word	2	11-29-2017 02:36 PM
Figures keep duplicating	telonghemu	Word	2	10-19-2016 04:47 PM
Updating Existing Information	akshaygopale	Office	5	06-22-2011 06:07 AM
Issue with Word duplicating	cajun62234	Word	4	04-06-2011 07:12 PM