Copy and paste multiple pdfs to excel with vba

Dear Sir

I have many pdf files in a folder
what i want is pdfs to be opened one by one,copy and paste in the sheet named text one by one
starting with A1 then after it pastes ,it has to open the next pdf in that folder and copy and come back to excel and paste in the same column in the next row.I have inserted a macro which can do the process for only one pdf.Looping vba is required for the next pdf is actually required .plz kindly help .

Please Login or Register  to view this content.

Hai dudes can you plz look in to my thread and give solution..

Hai can any one expert plz kindly look in to my excel and give solution

Hai friends can any experts plz help me with solution

Hai can any expert plz kindly look in to my excel and give solution

hai i have somewhat improved the macro
still i have some issues with this sheet
plz kindly help me out

Please Login or Register  to view this content.

i am unable to sort out what goes wrong