This script combines multiple PDFs into a single PDF, adds an note to each page, and saves the resulting PDF.
Steps needed for AUTOMATION:
a. Read data from Excel file. Column A = Item#; Column I = ItemType (L=Love; O=Open; F=Failed)
b. Use order of Item# in Column A in Excel file as order to combine PDFs
c. Open the first PDF. Clear any existing data. Add note to the bottom left of the page. Note: This first PDF will be the base PDF that all other files are combined into. note coordinates: 200, 7, 300, 26. Verdana 14 pt. Text color: Red. 2 pt. red stroke on box.
d. Open each subsequent PDF in order from list. For each PDF: Clear any existing note. Add note to PDF and then insert as last page of the first PDF. Close.
e. If possible, add bookmarks and thumbnails for each page.
f. Add page numbers in lower right corner. Coordinates: 820, 19, 848, 31. Verdana 18 pt. Color: Black. No stroke on box.
g. Save the combined PDF as the Excel spreadsheet name + ".pdf"
Note: Each note and page number box will need to have a unique object name.
Được trao cho:
9 freelancer đang chào giá trung bình $217 cho công việc này
Hi, I specialize in creating custom-made scripts for PDF files (google my name to see some examples), and can create this for you quickly and professionally. Contact me to discuss it further.
I am an Excel expert. I am a CA (Chartered Accountant). I can shut down computer from Excel and even crash hard disk. I can do it in Excel where a Macro will do the job in a single click. Excelolozy