Hi,
I currently have an excel 2003 document that I create multiple order files from opening a template and writing data to specific cell and then saving the file as the order number. But I would like to save the output files as pdf. Below is what I'm currently using:
Thanks for any help,
Please Login or Register to view this content.
David
Last edited by djfscouse; 07-28-2013 at 01:24 PM. Reason: Excel 2003
Snippet "borrowed" from "Microsoft Community"
AlfOffice 2003 doesn't have Save as PDF built in, this was introduced in Office 2007 SP2.
You'll need a third-party tool to create PDF, such as Adobe Acrobat (huge, cumbersome and expensive, but it is the "industry standard"), or one of the free/cheap alternatives such as CutePDF.
You can buy Acrobat, which installs a printer call Adobe PDF accessible from any application, or one of a ton of other PDF printers.
Entia non sunt multiplicanda sine necessitate
Hi David
I've used with success PDF Creator from pdfforge (free) at this link
http://www.pdfforge.org/pdfcreator
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Thanks guys but I already have software to create pdf files, what I was trying to find out is if its possible to create them from my vba shown on my first post.
Either way I appreciate your comments.
Please Login or Register to view this content.
Last edited by shg; 07-28-2013 at 05:15 PM.
Perhaps this link may be of interest?
http://www.excelforum.com/excel-prog...-to-a-pdf.html
Alf
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks