![]() |
|
#1
|
|||
|
|||
|
I found a very useful article on batch editing headers and footers in multiple word files in a folder. It was based on a macro for MS Word for Windows. I have modified for mac OS but I cannot get it to work.
I am using Mac OS with Office 2011. The code I am using is: Code:
Option Explicit
Public Sub BatchReplaceAll()
Dim FirstLoop As Boolean
Dim myFile As String
Dim PathToUse As String
Dim myDoc As Document
Dim Response As Long
PathToUse = "MacintoshHD:Users:user:Trial"
'Error handler to handle error generated whenever
'the FindReplace dialog is closed
On Error Resume Next
'Close all open documents before beginning
Documents.Close SaveChanges:=wdPromptToSaveChanges
'Boolean expression to test whether first loop
'This is used so that the FindReplace dialog will
'only be displayed for the first document
FirstLoop = True
'Set the directory and type of file to batch process
myFile = "MacintoshHD:users:user:desktop:Trial" & "*.docx"
While myFile <> ""
'Open document
Set myDoc = Documents.Open("MacintoshHD:users:user:desktop:Trial" & myFile)
If FirstLoop Then
'Display dialog on first loop only
Dialogs(wdDialogEditReplace).Show
FirstLoop = False
Response = MsgBox("Do you want to process " & _
"the rest of the files in this folder", vbYesNo)
If Response = vbNo Then Exit Sub
Else
'On subsequent loops (files), a ReplaceAll is
'executed with the original settings and without
'displaying the dialog box again
With Dialogs(wdDialogEditReplace)
.ReplaceAll = 1
.Execute
End With
End If
'Close the modified document after saving changes
myDoc.Close SaveChanges:=wdSaveChanges
'Next file in folder
myFile = Dir$()
Wend
End Sub
Anyone any ideas as to how to proceed? Any help would be great. Thanks Last edited by macropod; 02-22-2020 at 02:35 PM. Reason: Added code tags |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Batch applying a macro to remove Header and Footer using Batch Auto Addin
|
Edszx | Word VBA | 2 | 05-27-2019 11:16 PM |
| Editing Word documents through VBA in SharePoint | algecan | Word VBA | 0 | 09-26-2018 05:23 AM |
| batch extract all tables in multiple word documents | ZaidaBa | Word Tables | 3 | 05-08-2017 10:22 PM |
| Emailed documents locked for editing by someone else | jibbs | Office | 1 | 09-30-2015 05:12 AM |
Batch create Word documents
|
cdfj | Word VBA | 6 | 11-07-2012 01:03 PM |