reference - Updating page numbers in VBA -

-

i have word document uses many different fields. wrote macro updates sequence, reference, page, , numpages fields in document.

updating text fields reverts them default text don't want updated.

this macro worked in word 2007 updated word 2013 , doesn't work anymore.

all page , numpages fields set 1 when macro runs. yet when update them manually, update correctly.

was there change how fields updated in office 2013?

the macro code below.

sub updateallfields() unprotectdocument  'updateallfields macro     dim objdoc document     dim objfld field  'updates specified form fields. can take while when document gets large     set objdoc = activedocument     each objfld in objdoc.fields         if objfld.type = wdfieldref 'updates cross references             objfld.update         if objfld.type = wdfieldpage 'updates page numbers             objfld.update         elseif objfld.type = wdfieldnumpages 'updates total page count             objfld.update         elseif objfld.type = wdfieldsequence 'updates sequence fields             objfld.update         end if     next objfld  protectdocument  end sub

it happened me page references pointed page 1 in document when used activedocument.fields.update, worked when updated them manually. after trial , error noticed worked using selection.fields.update, modified macro following:

sub updateallfields() dim ocurrentrng range dim orng range  application.screenupdating = false set ocurrentrng = selection.range set orng = activedocument.range orng.select selection.fields.update  ocurrentrng.select application.screenupdating = true end sub

hope helps someone!

//david


Comments

Post a Comment

Popular posts from this blog

qt - Using float or double for own QML classes -

-
i've created components , helper methods using c++ , qt used in qml gui. of methods calculate gui elements (size, transformations, scene graph items creation). target arm 32 bit using opengl / eglfs render output. opengl using float , qml using real (defined double ). what should use in c++ do not lose precision? if use qreal ( double ) shouldn't lose precision. if git grep float in qtbase.git , can find out bit more: dist/changes-5.2.0-**************************************************************************** dist/changes-5.2.0-* important behavior changes * dist/changes-5.2.0-**************************************************************************** dist/changes-5.2.0- dist/changes-5.2.0- - qt compiled qreal typedef'ed double on dist/changes-5.2.0: platforms. qreal float on arm chipsets before. guarantees more dist/changes-5.2.0- consistent behavior between platforms qt supports, binary dist/chan...
Read more

Create Outlook appointment via C# .Net -

-
i need create outlook appointment using microsoft.office.interop.outlook , while can work locally on own workstation , works if run web application via server's browser, not work when connect server externally. hence, think might permission issue. i changed application pool identity " localsystem " don't access denied error. unfortunately, doesn't work. the app behaves if appointment created, appointment doesn't appear in outlook. here include file on top of aspx.cs page using outlook = microsoft.office.interop.outlook; here code using pop appointment. outlook.application apptapp = new outlook.application(); outlook.appointmentitem appt = apptapp.createitem(outlook.olitemtype.olappointmentitem) outlook.appointmentitem; appt.subject = txtfirstname.text + " " + txtlastname.text; appt.body = txtcomment.text; appt.alldayevent = false; appt.start = datetime.parse(txtreminderdate.text + " 8:00 am"); appt.end = datetime.p...
Read more

ios - Swift Array Resetting Itself -

-
i have 2 arrays: pointhistory , datehistory . have nstimer , , when timer runs out, action called. in action appending int pointhistory , , current date string datehistory . here timer action: func timeraction() { let steppervalue = int(stepper.value) employee.numberofpoints = steppervalue networking.saveemployee(employee, completion: { (error) -> void in if error != nil { let alert = uialertcontroller(title: "error", message: "there error updating \(self.employee.name)'s points", preferredstyle: .alert) let alertaction = uialertaction(title: "ok", style: .cancel, handler: nil) alert.addaction(alertaction) self.presentviewcontroller(alert, animated: true, completion: nil) } }) var dateformatter = nsdateformatter() dateformatter.dateformat = "mm-dd-yyyy" dateformatter.timezone = nstimezone.localtimezone() var date = nsdate() var ...
Read more