Application screenupdating not working vba Chat to honny woman free
You can download a userform to do this from my web site - Extract the files from the zip and import to the VBA project.
Good Morning Thanks for the quick response Re your comments Sensitivity issues precluded me attaching the relevant workbook and a mock up would not necessarilly be reflective of the complexity. File Dialog(mso File Dialog File Picker) If doc To Open. Range Dim o Frm As frm Progress Dim Portion Done As Double On Error Go To Err_Exit str Text To Insert = "Annual bonus rates for the last five years" str Text To Find = "Discharge Pack" Set doc To Open = Application. The following does that for the first instance of the found text (matching the case). Caption = "Processing document " & i - 1 & " of " & doc To Open. Count End If 'Open each document Set Doc = Documents. Selected Items(i), _ Visible:=False, _ Addto Recent Files:=False) Set rng To Search = Doc. Screen Updating = True Msg Box "Processing complete" End If lbl_Exit: Set Doc = Nothing Set doc To Open = Nothing Set rng To Search = Nothing Exit Sub Err_Exit: Msg Box Err. It appears that you want to locate the text "Discharge Pack" and insert a paragraph break after it and write the text to the start of that new paragraph. Execute(Find Text:=str Text To Find, Match Case:=True) rng To Search. Close Save Changes:=wd Save Changes Do Events Next Unload o Frm Application.