pdf objest

[NNNNN]

Hi

I am trying to convert documents from word to pdf using vba

I have adobe acrobat and a pdf printer installed and can manually click on convert to pdf which works fine. I just want to be able to automate the process for several documents.

Here is an attempt which needs some work

Dim pd As AdobePDFMakerForOffice.PDFMaker
Dim dc As Object

Set dc = GetObject("C:\mydoc.Doc")
With d
dc.CreatePDF
End With

 

[Remou]

You are likely to get more replies in forum68 or forum707.

 

[lameid]

There is a FAQ on this...

faq705-1635


Seems like it used Adobe Pro as the printer.

Might I also suggest the GNU project PDFCreator as an alternative.

You can set through the UI (takes some digging) to always save to a given file. Then you can do whatever you want with the file. In VBA. Cutepdf also has a pay version that allows setting the file name (via the registry if memory serves).

 

[PHV]

FYI, Office2007 has a free add-in to save a document to PDF.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[lameid]

I would not go to Access 2007 just for PDF printing, i.e. see thread703-1380654