Hi,

Can someone help me with a vba code to extract filenames and number of pages for word files (both .doc and .docx) from a folder and its subfolders into an excel sheet. One way I identified for doing this was to get the pages from details in windows explorer, but I dont know how to export this details to excel as explorer does not allow to copy these details. Also if we go by this method there were some .docx files which were showing incorrect page numbers, for eg. file contains 90 pages but the explorer displayed number of pages as 1. Is there any alternate way to achieve this without having to open each word file from all the subfolders.