Convert MS Office document to PDF

[vbakan]

Please help me if you can

I want to install Acrobat Professional on a net work PC and setup few network folders where users can save their MS Office 2002 documents (Mainly Word, Excel and Visio) in there. Then write some code to convert MS Office documents to PDF and save back to the network folder to access by the users. Here security is not my concern

I know MS Office 2007 has got some add-in to do this job, but we have Office 2002, therefore that option is not suitable.

Is any body has done the same could you please give me some suggestion

 

[SimonDavies]

I think the easiest way to do this would be to use the Adobe PDF printer that will be installed on to the workstation that has Acrobat installed to it, now however I am unsure if you can actually share the printer as a network resource (after all it's using locally installed software rather than printer drivers) but you may well be able to do something clever by running a scheduled task on the Acrobat based pc to print (convert) all of the documents that are stored in a parent folder and once printed to move said documents to a done\completed folder.

You may have to see about dos scripting this but it's a something for you to look into (unfortunately I don't have Acrobat installed on this box to help you out more with).

SimonD.

The real world is not about exam scores, it's about ability.

 

[SimonDavies]

I lied, it looks like you can share the PDF printer (at least on Acrobat 8) so that may be the way to go.

SimonD.

The real world is not about exam scores, it's about ability.

 

[vbakan]

Thanks for your comments SimonD, I am also have some dobut about "I am unsure if you can actually share the printer as a network resource" but if any one done the same before could help me with sample code ect

vbakan

 

[vbakan]

Hi SimonD

I need some technical guidance on this please on VB or VBA

 

[SimonDavies]

Hi mate, I just jumped onto my laptop (which has Acrobat 8), went to the Printer folder and looked at the properties for the Adobe PDF printer, in there I had the option of sharing the printer (it also says Render Print Jobs on Client Computers) so it's by feeling that this should just do what you want it to do.

As far as VB\VBA goes, unfortunately I am not a scripter\developer and don't know anything to do with that side of things.

SimonD.

The real world is not about exam scores, it's about ability.

 

[vbakan]

Thanks for your help, Do you know where I can get some coding help on this.

vbakan

 

[xlbo]

You do not code in VBA to create a PDF (unless there is a save as PDF option)

You may get some help in forum707
but to be honest, this sounds more like a job for VB than VBA

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[ajrimmer]

You could have a look at PDFCreator

http://www.pdfforge.org/products/pdfcreator/download

The install includes examples of code to use (including VBA) - though any questions on that are better asked in the relevant VBA section mentioned above.