How to convert MS Word files into PDF via VBA?

[sudakov]

Hello,
I have multiple (hundreds) MS Word files in a folder.
I would like to write VBA code to convert them into respective PDF files.

Does anybody know if this is possible?
Has anyone done it before?

Thanks.
Sudakov.

 

[dhookom]

I'm not sure why you asked this in an Access forum. You might have better luck in forum707.

Duane
Hook'D on Access
MS Access MVP

 

[genomon]

Download the free add-in from MS. Info on how, and sample VBA code, is here:

http://news.office-watch.com/t/n.aspx?articleid=1008&zoneid=30

An làmb a bheir, ‘s i a gheibh.

 

[sudakov]

Duane,
the reason I asked my question in Access forum is that I plan to incorporate the code into a MS Access application.
However, I have followed your advise and re-posted it in forum707: VBA Visual Basic for Application (Microsoft).

Genomon,
sorry I forgot to mention I use MS Access 2003 where export to PDF (acFormatPDF) is not available, unlike MS Access 2007.
The article tells how to export a REPORT into PDF, not a MS Word file.

Thank you both for your replies.

 

[genomon]

Unfortunate about the Access version; the VBA works the same in Word with different param constants however.

An làmb a bheir, ‘s i a gheibh.

 

[sudakov]

Genomon,
I see what you mean and correct me if I am wrong - you suggest to execute VBA code from MS WORD 2007.
However, MS Office 2007 is not available in my work environment yet.

Thank you.

 

[genomon]

Yup. There are some 3rd party libs out there to write PDFs in VBA; we used to use the ACG Pdf & Email lib. Or if you own the PDF Writer (full version, not reader) you can set a project reference in the VBA IDE. I never found much for VBA samples though, and Acrobat doesn't really support the VBA stuff - they seem to love Java though as there are lots of samples for that on the Adobe website. Otherwise if you are able to set the lib reference you can cruise around in object browser & see what works for you.

An làmb a bheir, ‘s i a gheibh.

 

[sudakov]

Hi genomon,
thank you.

I let you know if I can figure it out myself how to use Adobe's API.

Thanks.
Sudakov.