Hi,

I want to extract a page no.'s of documents in a folder.

In a Excel Column A is File name & Column B is Page No.'s

While running a macro file names in a folder should get copied into Column A and then corresponding page no's get pasted in column B.

I dont know whether it is possible through VBA or not, if it does not seems realistic please excuse.

I tried with RegExp.Pattern = "/Type\s*/Page[^s]" , its not working. its working only with PDF formats.

Format : ".docx" & ".rtf" & ".pdf"
Folder selection by browse option.
Strpath = Input("Please enter files pat")

Your Help is highly appreciated ...