Is there a way that the pdf file can create a folder on the users desktop and save the file with a file name based on specific cells in the sheet? I am trying to combine pdf's into one single pdf with the use of vba. The pdfs show and text can be manually copied and pasted into the excel document.
If multiple copies of the same sheet are saved/printed to pdf can each copy have a number eg. I am currently using microsoft excel 2010. I have a code that converts the pdf to excel already, but i would like the macro to put each separate page of the pdf file in a different worksheet in my excel file ( currently it copies all of the pages and pastes page 1 of the pdf into a worksheet).
How to import multiple text files from a folder into one. I have to convert the pdf file to excel to read the data easily and use them as i want. Is there any solution ? A pdf file is essentially a text file, on steroids.
What i have found so far through searching the web: I tried manually saving these two pages using selection in the options dialog to save the two sheets i had selected, but got blank pages. Trying to insert some pdf files into the spreadsheet. But i didn't find any snippet code help to do this in c#.
Post back if you have additional questions. When i tried the active sheet (s) option, i got what i wanted. I have tried something like, but cannot seem to. I find some free dll like itextsharp or pdfsharp.
I am currently doing this through sendkeys a. All of the pages have the same heading if that helps at all. I have set the column width and row height in cm, as i want to print at a specific size (it's a file of name tags that have to fit. 2, 3 in the filename based on the copy number?**
Also, if you want to consider converting all pdf files in a folder to text files, you can easily import text all text files into a folder into excel, and then manipulate any way you want. I would like to not use a plug in tool and have tried with acrobat api below. I'm working on a program in python, the program would read data from a pdf and i'm supposed to populate the same information in a excel sheet right now i'm using.