Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-16-2023, 12:22 AM
whistler1 whistler1 is offline Sort a folder of .docx files by page size Windows 11 Sort a folder of .docx files by page size Office 2016
Novice
Sort a folder of .docx files by page size
 
Join Date: Jul 2023
Location: gateshead, UK
Posts: 8
whistler1 is on a distinguished road
Default Sort a folder of .docx files by page size

I have a LOT of files in .docx format

Some are A4 some legal page size


Is there an easy way to sort the files by page size
(NOT the size of the document, bytes etc, but the page size for printing)


or alternatively is there some batch command that would allow me to rename them based on page size - eg documentA4.docx, documentLegal.docx
Reply With Quote
  #2  
Old 07-16-2023, 04:27 PM
Guessed's Avatar
Guessed Guessed is offline Sort a folder of .docx files by page size Windows 10 Sort a folder of .docx files by page size Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

There isn't a way to sort files based on page size. In any case, page size can vary from section to section so any document can 'have' a variety of page sizes.

It would be possible to create a macro to open each document, find out the page size of a particular section in it (eg First) and then append the name of that page size to the filename.

Note that if you put it at the end of the filename like your example then you still won't be able to sort on that characteristic.

The macro could also write the paper size to a document metadata field which can be shown as a column in Windows Explorer. You could then sort by paper size without changing the filename.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete last page of .docx and then save as .pdf for all the files in a folder kalton Word VBA 2 01-23-2020 10:05 PM
Looping through a folder of PDF files and saving them as docx ballpoint Word VBA 5 11-22-2018 05:18 AM
Sort a folder of .docx files by page size Run Code on all files and save files as .docx Plokimu77 Word VBA 4 06-05-2016 04:41 PM
Sort a folder of .docx files by page size Macro to change all text color to black in all docx files in a selected folder joewoods Word VBA 13 05-16-2016 06:29 PM
Size of pst files is 6x larger than the "total size" of the personal folder ken3 Outlook 2 03-31-2011 09:01 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:24 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft