I would like to know if anyone has been able to come up with a way of converting office documents, excel, word and so on, to pdf from vb or with vb script? I deally I do not want to have to purchase a product, so anything that works that is free would be great. I have a system at present that can do it but it has to be run manually, it is an additional applicaiton.
There's a couple of inexpensive PDF print drivers out there, including zeon docucom, which can be automated.
You can use CutePDF for free, but, it has to be run manually.
One approach I've used in the past is to set up a postscript printer, and configure its default mode to print-to-file. Then, automate ghostscript to convert the postscript file generated in the prior step to pdf, and kill the source postscript file.
In your case, you would set the postscript printer as the default, automate the office application to open/print the document to the ghostscript printer, process the postscript file with ghostscript, and finally kill the postscript file. Then, repeat until done.
Last edited by loquin; 05-13-08 at 12:33.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert