Thread: Change page size for hundreds of documents
View Single Post
 
Old 08-24-2020, 07:56 PM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2016
Expert
  
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
You could probably use the custom process of https://www.gmayor.com/document_batch_processes.htm to make the changes, but you will have to modify your macro to work with it. There will inevitably be formatting changes, but without knowing what is in the documents it is impossible to be precise about what needs to change. The following will get you started.



Code:
Sub Resize(oDoc As Document)
    If oDoc.PageSetup.PaperSize = wdPaperLetter Then
        oDoc.PageSetup.PaperSize = wdPaperA4
    End If
End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote