Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington (Greater Manchester area)/Cheshire, UK
    Posts
    153
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Wrod, VBA, and PDFs

    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

  2. #2
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 Posts

    Re: Wrod, VBA, and PDFs

    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.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington (Greater Manchester area)/Cheshire, UK
    Posts
    153
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Wrod, VBA, and PDFs

    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

  4. #4
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 Posts

    Re: Wrod, VBA, and PDFs

    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.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Australia
    Posts
    1,294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Wrod, VBA, and PDFs

    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.

  6. #6
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington (Greater Manchester area)/Cheshire, UK
    Posts
    153
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Wrod, VBA, and PDFs

    Thanks Diana and Andrew.

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

    James

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •