pdfs

So we receive hundreds of invoices from our customers every day. The invoices are in pdf format but such that you can select the text and copy and paste etc Is there a way to convert multiple pdfs of invoices into data so that I can see it Excel or Word?

I have embedded several PDFs into an Excel spreadsheet using the process detailed here: https://www.youtube.com/watch?v=btzTt8whcL4 When I try to open them (either by double clicking or by selecting Adobe Acrobat Object -> Open) nothing happens. I'm using MS Excel 2016, and Acrobat Reader DC.

Hello! I have a workbook with 39 tabs that need to be saved individually as PDFs. To save myself time, I created a macro that does this. Code is below. Problem is, I can't get the PDFs to be saved/exported to a specific folder consistently. I've tried a few solutions I looked up online, but...

Hello, I am running excel 2016 in windows 10 OS, laptop. Every month at work I receive 20 PDFs about the stock in 20 warehouses. Every warehouse has an ID number at the top of every PDF, for example A00 and the total value of the stock in the bottom. I want to create a macro which can...

Hey Guys I have a list of numbers in column A, and a folder with pdf's in. The pdf's have the same file name (excluding extension) as the data in column A I am trying to create a formula that will automatically hyperlink the pdf as currently someone is spending a stupid amount of time doing...

Hello, I have a macro that that fills out a template with textboxes and cells, then it prints to PDF via ExportAsFixeddFormat. It works great on the first run (creates 31 seperate PDFs each run), then on the second run (exact same data), it seems to be running great and bam after roughly 4 PDFs...

Hi all, Say I have a few pdfs, I list location/file name in cell, 1 pdf file with 5 pages, and a few other pdfs, is there any vba code that can combine this into one pdf? Is this possible?

I have a statement with invoices. I have a folder with individual PDFs for each invoice. After reconciling, I will need to print the non-reconciled invoices. The invoice reference is part of the text string of the file name. Would I be lucky enough that someone has a macro already for this.:)

Hi All, I am sorry for repeating this question, as I had posted it in another thread. My question is: I have a Listbox, in which the PDf files of a folder is listed. Below is a program to merge PDFs. I want this program to take the contents of this Listbox and combine them into one. Request...

Hi, I have more than 1000 pdfs and I need to copy some specific texts from them on the basis of keyboard. It is just like vlookup. Is it possible, totally helpless and it is very hectic to copy and paste from 1000 pdfs. Please help. Any help in this regard will be highly appreciated....thanks...

Hi all, I'm hoping that there is a possible solution to my dilemma. My intention is to create an electronic contract system using mail merge, excel vba, and PDF manipulation. However, I'm trying to automate the process as much as possible. The desired result is to email PDFs to 1000+...

I'm trying to create a macro that saves different worksheets in my workbook as different PDFs. The worksheets are called "T-88" "T-89 & T-90" "T-99" and "Report". All the PDFs need to go into this location. C:\Users\jdavis\Dropbox\Quality Control\Jobs. From the jobs folder it needs to find...

Sorry to post on an Excel board... But I need a quick way to save multiple Word.docs as multiple PDF's. Possible ? Thank you!

I have a macro that cycles through all values in a pivot filter and saves individual PDFs for each filtered value. The problem is the macro will save the PDFs in the current excel file location. How do I adjust the macro to prompt the user for the folder location to save the PDFs? The prompt...

I have a spreadsheet "Contracts.xls" and I would like to be able to open PDFs via a hyperlinked cell on each row. The PDFs are stored in the same directory as the spreadsheet. For example, for contract 0001 I have a pdf in the same directory named 0001.pdf. The path to the directory will change...

I have a bunch of PDfs in a folder and am creating an Excel doc with a hyperlink for each PDF in a unique row (later I will insert work related notes about each PDF). The PDfs in the folder are currently named 1 (1), 1 (2), 1 (3), etc... I am using a formula that seems to work...

I think this is possible but am not even sure where to start. I have sheet 1 with a list of 50 values in column A (names of people). On sheet two I would like each each name to go into cell C2 which looks up though IF statements a bunch of stuff from sheet 3 and fills it in on sheet 2. After...

Hi Gurus, I have a folder full of pdf files which have similar template. I want to copy the data from each of these files into separate sheet of a workbook. I have extracted the list of files and file paths in the workbook and tried to run this macro My predicament is that this macro only...

I have a macro that opens and consolidates PDF files. This requires the reference "Acrobat" which is pointed to the Acrobat installation folder's file "acrobat.tlb." With Excel and VBA open, I add this reference and the code runs successfully. However, if I save and close Excel, then reopen...

I have a list of PDF files in a folder. I wanted to know how exactly would I write a vbscript to go into the folder, take the file path and put it in an excel worksheet in column A and offset it until all the files have been caught. Also I know this is probably an easy question and an easy macro...