Save to PDF using VBA in Word 2007

Tutorials Win: Microsoft Windows Forum

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
Top

Re: Save to PDF using VBA in Word 2007 by Doug

Doug
Thu May 24 08:50:58 CDT 2007

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" <NoSpam@Hotmail.com> wrote in message
news:u7Pn9cgnHHA.4624@TK2MSFTNGP04.phx.gbl...
> 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
>


Top

Re: Save to PDF using VBA in Word 2007 by Adrian

Adrian
Thu May 24 10:46:58 CDT 2007

Doug,

Thanks. Looks like just what I want.

Adrian
"Doug Robbins - Word MVP" <dkr@REMOVECAPSmvps.org> wrote in message
news:eG7sTqgnHHA.4188@TK2MSFTNGP02.phx.gbl...
> 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" <NoSpam@Hotmail.com> wrote in message
> news:u7Pn9cgnHHA.4624@TK2MSFTNGP04.phx.gbl...
>> 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
>>
>
>


Top

Re: Save to PDF using VBA in Word 2007 by Adrian

Adrian
Fri Jun 15 02:32:18 CDT 2007

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

"Doug Robbins - Word MVP" <dkr@REMOVECAPSmvps.org> wrote in message
news:eG7sTqgnHHA.4188@TK2MSFTNGP02.phx.gbl...
> 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" <NoSpam@Hotmail.com> wrote in message
> news:u7Pn9cgnHHA.4624@TK2MSFTNGP04.phx.gbl...
>> 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
>>
>
>


Top

Re: Save to PDF using VBA in Word 2007 by Jean-Guy

Jean-Guy
Mon Jun 18 12:55:54 CDT 2007

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
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org


Top

Re: Save to PDF using VBA in Word 2007 by Adrian

Adrian
Tue Jun 19 13:51:13 CDT 2007


"Jean-Guy Marcil" <DontEvenTry@NoSpam> wrote in message
news:u96D4HdsHHA.5008@TK2MSFTNGP03.phx.gbl...
> 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
> jmarcilREMOVE@CAPSsympatico.caTHISTOO
> Word MVP site: http://www.word.mvps.org

Jean,

Thank you. I will give it a go.

Adrian


Top