How to automate compression of PDF files in Adobe via Access (VBA)? (1 Viewer)

JD_TheMaster

New member
Local time
Today, 15:55
Joined
Feb 14, 2021
Messages
5
Hello all. I've been looking for an effective solution to my query for a while but haven't got any luck thus far.

Essentially I've been trying to find a way to automate compression of PDF files in Adobe via Access. The Adobe method of the following procedure is as follows:

File > Save As Other > Reduced Size PDF > Ok > Save > Replace existing file if exists

I need to run this Reduced File Size for bulk files. Initially I created an action to do it. But now I wanted to move to using Access to do the heavy lifting for me instead because I have more Adobe related tasks that I want to achieve in Access; automating the compression is the beginning step.

A while ago I tried asking about writing a script using VB in the Adobe community but that didn't really elicit any strong responses.

I've had a look at some of the Adobe references in VB but wasn't able to understand how to proceed further.

Does anyone have experience or has ideas on this topic? I'm new to Access so this is all a little overwhelming. Thanks.
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 00:55
Joined
Feb 28, 2001
Messages
19,384
I have no direct experience here, but the usual way you do that is that first you need a level of Adobe software that allows this to be done manually. Then you have to find the Adobe library. I don't have one that creates files like you describe, so I have to guess. But basically, if you can find that Adobe utility's library (a .DLL file, probably) and make an Access reference to it (from VBA screen, Tools>>References and then find & check the Adobe libraries), you can then use VBA to create an Adobe Application Object that can be told to open a file and do a programmatic SaveAs with some options such as you describe.

Here is one article for you to get started:


You just have to search for Adobe VBA to find several references.
 

Users who are viewing this thread

Top Bottom