Execute a program on VBA (PDF converter)

Dear friends,

I receive lots of PDF files per day that I need on Excel.

I wanted to create a macro that executes the program that I have (Abel2Extract) to convert the pdf files to excel and copy the result into my page.

I'm really sorry I don't have any beginning code to share with you. I'm not lazy...I'm just a noob with grandious ideas that doesn't know how to execute them.

I'm do not want you to write the code for me, just to point me in the right direction.

I've searched and I know I have to use the Shell function...but I have no idea how to do it (I already saw gigantic lines of code online to run such a thing)

Thanks in advance,

Dresur

Idea / Suggestion:

According to the help file, Able2Extract has the ability to convert PDF files to Excel via the GUI, batch, and command line mode.

Command Line mode! If so, that's great. This gives you the option to make this a two-step process.

You write a DOS batch file that converts all of the PDF files you have to Excel. This way you don't have to worry about doing this with the Excel macro you create. Your Excel macro will only have to grab the data from the newly created Excel files and manipulate it or do with it what you want.

Does that make sense? That seems easier, at least to me.