Using the PDFTables API, you can use VBA to convert PDF to Excel.
Our algorithm can 'see' tables and understands the spacing between items to identify the rows and columns, much as your eye does when you scan a page. You can use our free API and the macro we've created to convert PDF to Excel using VBA, whilst in Excel. In our macro, you'll find VBA code to extract data from PDF to Excel.
Options) and navigate to the
Customize Ribbontab, then on the right hand side, tick the box next to
Developer. Click OK to close the dialog.
Developertab at the end of the main ribbon, and click the
Visual Basicicon (on the far left).
Run Macrobutton in the toolbar, or press F5 on your keyboard, and select