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.

This is my requirement, I dont know how the above code will get works...

Please review and do the needful..