Here to fore, I have saved everyone’s account information as an excel file. Today, I would like to import thier excel information into an adobe pdf. This is kinda daunting because I have 300+ files to convert every month. So, I need to be able to import a microsoft excel file into adobe acrobat, and save it as a pdf. It would also be nice if I could process them automatically. Does anyone out there have any suggestions?
Download and install Open Office. Open Excel file in OO, press PDF export button. You’re done!
Henceforth you can use OO and uninstall MS Office completely.
Does open office allow me to write a macro which could open the excel file, and save it as a pdf, and then move on to the next excel file?
In Acrobat 6.0, you can simply highlight your excel files in a big chunk without opening them, right mouse click and select “conver to pdf.”
Or are they in 300 excel files and you want them in 1 Acrobat file?
We have about 300 excel files that we need to make into 300 adobe acrobat files. We then need to mail them electronically to 300 different customers. Which puts me attaching 300 attachments to 300 emails.
Which is kinda why I need to automate the task.
Since you’re a business, I’ll assume you’re using Outlook. Since you say Acrobat, I’ll assume you have it, and that it’s version 6.
Therefore, in a new email message, there’s an “Import as PDF” button in the toolbar. This is partial automation.
If you tell me you’re using Entourage for email, then I could probably find an Applescript to automate the entire process, and you won’t even need Acrobat.
I use pdf995 to create all my pdf files. It installs as a printer driver. You simply format all your print options as though you are making a hardcopy but it saves a pdf file with all the data. It is free if you accept the little ad that pops up after use which is no inconvenience at all. It actually works sometimes where Adobe’s own product doesn’t so we use nothing else.