Updating fields word document
Before we get into specifics, note that a lot of keyboard shortcuts are involved in working with fields, and some of them are the only way to accomplish a particular action.
Table 16.2 includes a quick summary of these shortcuts.
Field Doesn’t Update Remember, most fields do not update automatically.
To manually update a field, right-click it and choose Update Field, or select it and press F9.
Here's my Excel Macro code: 0 Run Update(Path & "\" & Word File) Word File = Dir Loop End Sub Function Update(Filepath As String) Dim Word Doc As Word. Open(Filepath) 'This produces the error Active Document. Update End Function Note that the only files in the folder are the 3 documents and the spreadsheet, and the program does find the files without any problems. When I run it, I just get the "Excel is waiting for another application to complete an OLE action." error over and over again and Excel becomes otherwise completely unresponsive.
Document Set Word Application = Create Object("Word. I have searched for solutions online but I did not really find anything, which I found odd, since it seems like a pretty common thing that someone would do with VBA. When I try to run this on a file with linked fields, the document simply fails to open and the Excel macro stops running without raising any error. The strange thing is that if I run it step by step everything works perfectly until the line where it opens the file (I checked the file path with the debugger, it's correct).
Also examine the field’s code and make sure that the switch is not present.
, so they are never updated even when someone issues an Update Field command on them.
To update multiple fields at once, select them as part of a contiguous selection range and press F9.
To update all the fields in the entire document, select the entire document (Ctrl A) and press F9.
(In this way, they differ from OLE linked objects, which are automatically updated by default.) To update a single field, select it (or click anywhere in it) and press F9, or right-click the field and choose Update Field.
If you have toggled the display of the field code string on, updating the field toggles it back to displaying the results.