PDF To Excel

[YesImAk]

Hello,
I'm pretty new in Excel VBA so I don't know much about it. Basically I want to create a tool which can take PDF files from the folder in which the excel sheet is saved and paste them in Excel rows, Like if there are 4 PDF Files in my folder then I want the tool paste all of them in different columns. (eg: Test1.pdf in A1:A100, Test2.pdf in B1:100 and so on).
I'm looking for someone who can help me with this tool and sorry for my bad English.
Thank you in advance!

 

[nemmi69]

Are you looking for just the names, directory reference or something else?

 

[YesImAk]

Are you looking for just the names, directory reference or something else?

If you are asking about the PDF content I wanna copy everything inside the PDF file and paste them in Excel.

 

[nemmi69]

The only way that I know how to do that is via 365

 

[YesImAk]

The only way that I know how to do that is via 365

I do have Microsoft 365 with active subscription

 

[nemmi69]

You could try recording the initial process of going to the "Data menu", "Import from File", "from PDF"

 

[YesImAk]

You could try recording the initial process of going to the "Data menu", "Import from File", "from PDF"

That will import the PDF as an Table right?

 

[nemmi69]

Guessing so, never tried it