Creating Excel files from a PDFs VBA

[joeshu26]

Hello,

I have a list of identification numbers that all have individual folders on a LAN. Each of these folders has a pdf document associated with that ID number. I need code that will go into the ID number's folder and open that PDF document and save it as an excel workbook (with the name of the workbook being simply the ID number). I then need this macro to loop and do this for the rest of the list of ID numbers.

I know this is extensive, but I need some help or a push to get started!

Thanks,
Joe