Using VBA Power Query to import PDF tables - MrExcel
May 30, 2018 · Importing PDF into Excel using VBA I have a PDF that has multiple tables (page header, detail, summary footer) and multiple pages. I am looking to import this PDF into Excel …
Line thickness problem when printing to pdf - MrExcel
Jan 20, 2018 · Hello everyone. As you may have already exprienced yourselfs, excel is not producing nicely looking pds when it comes to linetype and line thickness representation for …
PowerQuery question: what's the best way to fix misaligned …
Dec 1, 2022 · Hello, I'm trying to import several PDF files into PowerQuery. There's a section in the PDF that looks like this: However, when I import the PDFs, the columns keep getting …
Combine multiple PDFs with multiple pages into excel.
Jul 8, 2022 · It's a daily report for each PDF and I need to combine all the PDFs into one excel. There is no option to select multiple pages in the "import from folder" data query as far as I am …
Create an Excel lookup table from pdf files
Dec 26, 2021 · Is it possible to create an Excel lookup table from pdf files. I have thousands of (8815) pdf technical drawings in a "PDF_TubeType" attached file and want to search this file …
VBA for extracting specific data from PDF Docs - MrExcel
Oct 27, 2008 · Word VBA code (called from Excel) can be used to open each PDF as a Word document and search and extract the required data. The code in this thread shows the basic …
Import PDF into power query using vba - MrExcel
Nov 8, 2011 · Hi all I am trying into import a pdf file into power query using vba. the format of the pdf table is the same just the data changes. I want to try to make it generic so that I can import …
Extracting string from PDF and inserting into Excel using VBA
Mar 23, 2022 · To in fact select that string and the following characters and copy that to excel? OPTION 2 The other solution I tried was what I found on this forum from people with similar …
VBA to search for table from PDF File and copy and paste to …
Oct 3, 2023 · I have a work sheet that I have the operator click on a button, and it lets them select a pdf file. I have it so the pdf file converts to an excel table: Private Sub …
Power Query Does Not Import Multiple PDF Pages - MrExcel
Jun 5, 2014 · I think I see the problem. I'm not technically connecting using "PDF" data source, I'm using "Folder" and when I do that it shows PDF file with 10 objects, of which 5 are tables (the …