Sampoline
02-12-2021, 07:09 AM
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.
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.