W
WC Justice
I use an application that uses Automation to create a Word document from
within Access. After checking and possibly correcting the Word document, we
then print the Word document to a pdf file. Some of our computers have
Acrobat Professional
7.0, while others have PrimoPDF. This process is acceptable except that we
have to go through so many manual steps.
I would like to be able to generate the pdf from within Access using vba, or
at least from within Word. I get close, but don't quite get it. We make
extensive use of Automation, so I am familiar with the basics. I have no
trouble opening the specific document in hidden mode. I even get the file
to save as a pdf, but it about 10 x larger than it should be and is
apparently not really a pdf file.
As a recap, I would like to be able to use vba to go direct from Word to pdf
with no manual intervention (the filename and location do not change, only
the extension.). Even better would be to accomplish this through Access, as
we use Access to create the initial Word document.
Searching the internet makes it clear that it is not as easy as I thought it
would be. I've seen references to Acrobat Distiller and code modifying the
Windows registery for every print. Can you help me simplify this?
within Access. After checking and possibly correcting the Word document, we
then print the Word document to a pdf file. Some of our computers have
Acrobat Professional
7.0, while others have PrimoPDF. This process is acceptable except that we
have to go through so many manual steps.
I would like to be able to generate the pdf from within Access using vba, or
at least from within Word. I get close, but don't quite get it. We make
extensive use of Automation, so I am familiar with the basics. I have no
trouble opening the specific document in hidden mode. I even get the file
to save as a pdf, but it about 10 x larger than it should be and is
apparently not really a pdf file.
As a recap, I would like to be able to use vba to go direct from Word to pdf
with no manual intervention (the filename and location do not change, only
the extension.). Even better would be to accomplish this through Access, as
we use Access to create the initial Word document.
Searching the internet makes it clear that it is not as easy as I thought it
would be. I've seen references to Acrobat Distiller and code modifying the
Windows registery for every print. Can you help me simplify this?