• Wrod, VBA, and PDFs

    Author
    Topic
    #353558

    Has any got any experience in using VBA in Word to save Word documents as PDFs?

    (I do have the Adobe Acrobat programs and utilities installed.)

    Thanks

    james

    Viewing 0 reply threads
    Author
    Replies
    • #517625

      Is there a reason you don’t want to use PDFMaker which is the VBA macro that Adobe Acrobat installs when you install Acrobat? It does a whole lot more than just print the file.

      I find it much simpler to include in the VBA the code which calls that macro.

      • #517820

        I would like to, but it the Adobe Acrobat macro that I did try requires user and I would like to run without user intervention.

        Anyone got any pointers on how to do this or could point me in the right direction?

        James

        • #518040

          I would use some code to work out what file name and where I want to save it then call the Acrobat macro and then Send Keys to do the user intervention parts.

          Failing that I would just try printing the file to the Acrobat Writer or Distiller printer drivers. This method doesn’t bring across any hyperlinks though.

          • #518044

            If you dont want any user interaction the following will work:
            Assuming that application you have is Adobe Acrobat Distiller

            Obtain storage location & file names that you want to convert.
            Open files & then print to file (this will convert file to post script file) & save in location the ‘IN’ folder required by distiller.
            Then distiller will convert all files in the in folder to PDF & store in the out folder.

            Does this help?
            Diana

            I would like to, but it the Adobe Acrobat macro that I did try requires user and I would like to run without user intervention.

            When you say

            I would like to, but it the Adobe Acrobat macro that I did try requires user and I would like to run without user intervention.

            • #518386

              Thanks Diana and Andrew.

              I’ll try both methods and see which works best.

              James

    Viewing 0 reply threads
    Reply To: Wrod, VBA, and PDFs

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: