Consulting

Results 1 to 2 of 2

Thread: How to reduce file size (compress) a PDF using vba code in Access?

  1. #1

    Question How to reduce file size (compress) a PDF using vba code in Access?

    I want to automate the compression of bulk files from a folder location using VBA. I'm using Adobe Acrobat Pro DC as my primary default read, write and edit PDF platform.

    Obviously I can simply do one of the following:

    1) Open a file- File > Save As Other > Reduced Size PDF > Retain Existing OK > Save (Over Existing) in Adobe.
    2) Create an Action- Reduce File Size and Save > Run Action

    But I'm trying to find a way to do these through VBA as bulk. So obviously have Application.FileDialog(PickType) that can let me browse for the folder and then it runs a bulk Reduce File Size on the files.

    After doing some extensive research online, I haven't found anything conclusive. Anyone here have ideas on this matter?

    Thanks.

  2. #2
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    Sorry, I have no ideas at all.

Tags for this Thread

Posting Permissions

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