This Python script uses the tabula-py and pandas libraries to convert a PDF file into an Excel file. Each table in the PDF file is written to a separate sheet in the Excel file.

I have some VB experience, but I've never worked with excel's VBA so I didn't know what sorts of objects/methods there were to try to write it myself.<br><br>Sheet name won't be a problem.