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.
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.
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.