adobe

Hi everyone, If anyone at all has experience or can help me out with using VBA to create a password protected output file using Adobe DC (or similar Adobe product) I would be eternally grateful! Best. Mr Excelinator aka Stu

I am trying to parse specific measurements contained in some 3500 PDF files so they can be graphed and trends can be analyzed. The problem is that sometimes my code can loop runs 30 times before I get the "There was an error opening this document. This file cannont be found." from Adobe...

I created a program in VBA that reads through a PDF and pulls certain information into the worksheet. However, this only works with Adobe Pro. Does anybody know how to do this without Adobe Pro?

Hello, I have an Excel file where the final sheet generates an invoice. Each customer’s invoice is generated separately by means of a drop down box. When I select the customer from the drop down box, their invoice appears. I have to save each invoice as a separate PDF (the invoice sheet only)...

Does anyone know how to on the Excel VBA side or Adobe PDFs side to use Excel to help populate fillable forms that are in PDF format? I have found a few thing on the internet from the Adobe side, but it seems like I do not have the sufficient "level" of Adobe to allow this type of...

I am trying to convert an 800 page PDF file into Excel so I can automatically update pricing information. I have tried a number of different sources and have not had any luck with this conversion. There are programs that will export the data into Excel applications, but it does not do it in a...

I was creating a form in Excel: BusinessName:___________________________________ Address:___________________________City:__________ (etc) I'll be compiling the results into a larger spreadsheet or table. ...and I realized this would be better as a .pdf form (that's an option, since I have both...

Hey guys I've converted a pdf file to excel and now there are some formatting issues. One of the biggest on is that the data i want to use is in a single cell. Here's an example: "1 Car Rental/Gas 0.00 0.00 421.43 36.01 0.00 0.00 0.00 457.44...

Hello! I have a code that allows me to open a pdf file from Excel: Sub RunPDFWithExe() Shell "C:\Program Files\Adobe\Reader 9.0\Reader\AcroRd32.exe S:\Benefits\Leave of Absence\LOA Forms\Alisha\FMLA Alisha\LOA Packet.pdf", vbNormalFocus End Sub What can I add to this code that will have it...

I am attempting to pull down the contents of a particular PDF and I don't want to have to manually launch the URL, select all, copy all, open my excel file, and paste all. Any help would be appreciated... Below is the non-working code I have so far: Sub Read_PDF() 'References: Adobe Acrobat...

Aloha! I have a PDF file which is used to auto-populate form fields. Usually it is just from one field to another on another page within Adobe so it doesn't need to be entered more than once. E.g. a name or member number. There is, however, one date field which when entered needs to generate a...

I have a list of names, and currently I enter each name one at a time into a report and print that report. I need the macro to cycle through all the names in the list, and print the report for that name. I have to print to Adobe PDF. Can I write a macro to print from an Excel (2007) worksheet...

Is there any way to make an adobe pdf file open through an excel macro? I work in the banking department where our bank statements are emailed as pdf files. The name with which the files are saved are available in Cell A1 of my workbook. Is there any way to run a macro which will open the pdf...

I have a question... I have an Excel workbook that has hundreds of comments on several cells. To upload this document I am required to convert it to PDF. However, when I convert I lose all the comments. Does anyone know how to retain these roll over comments when converting?

I have a problem, that appears to be excel related rather than adobe pdf related. I have an excel spreadsheet that I have used for about 1.5 years and last used it about three weeks ago. It is legal paper size (8.5 x 14) and when I print it to a printer, it prints fine. When I print it to pdf...

Hi, I've been working on this problem on and off for a number of months now and have just about got it sussed so thought I'd share it with you as it has mostly been down to postings on this board that I've got it in the end. Thanks especially to 'biggoan' for his post...