Save to PDF using VBA in Word 2007

[Adrian]

Word 2007

Is it possible to use VBA to save a Word doc in Word 2007. We have installed
the 'Save to PDF' add-on. Currently we use PDFCreator but find it
unreliable.

Thanks for any help.

Adrian

 

[Doug Robbins - Word MVP]

Check out the Document.ExportAsFixedFormat method in the VBE Help file

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Adrian]

Doug,

Thanks. Looks like just what I want.

Adrian

 

[Adrian]

Doug,

We actually run the VBA code to open and save a Word doc to a PDF file from
Access 2003, so presumably we cannot use the Document.ExportAsFixedFormat
method as this is not available in Access 2003. Any other suggestions?

Thanks for your help.

Adrian

 

[Jean-Guy Marcil]

Adrian was telling us:
Adrian nous racontait que :

Doug,

We actually run the VBA code to open and save a Word doc to a PDF
file from Access 2003, so presumably we cannot use the
Document.ExportAsFixedFormat method as this is not available in
Access 2003. Any other suggestions?

Your initial post was about Word 2007, Doug pointed out the
"Document.ExportAsFixedFormat method", which is from Word 2007.
It does not matter what version of Access you are using as long as the code
points the Word object library, the Document.ExportAsFixedFormat method
should be available. I bet it would work with Access 95... although I would
not want to have to create a Word 2007 object from Access 95...

--

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[Adrian]

Adrian was telling us:
Adrian nous racontait que :


Your initial post was about Word 2007, Doug pointed out the
"Document.ExportAsFixedFormat method", which is from Word 2007.
It does not matter what version of Access you are using as long as the
code points the Word object library, the Document.ExportAsFixedFormat
method should be available. I bet it would work with Access 95... although
I would not want to have to create a Word 2007 object from Access 95...

--

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

Jean,

Thank you. I will give it a go.

Adrian