PDA

View Full Version : create path to .pdf and extract sheet size



wizard0
10-05-2015, 01:16 AM
Dear all,

Right now at my work I have to create a work folder (physical to use in the shop). This work folder consists of more than 100 .pdf files. Right now my work through is as following:

-Open first .pdf file
-Open PDFill and insert all files in order listed on the first .pdf file
-Merge all .pdf's
-Sort merged .pdf by sheet size
-print all

Now i'm almost certain excel can make my work go alot easier but I don't know where to start. I have some basic VBA skills and right now i'm thinking like this:

-Create list of .pdf files from first .pdf in excel
-use macro to extract path from .pdf file (by search or recurse?)
-use a macro to extract sheet size from .pdf file
-use macro to open PDFill copy paste all path's from files with size "x" and merge

So if I got a list containing three types of sheet sizes then I would get 3 merged pdf files.

Can anybody help me out by first telling me if the things I would like to do are even possible. After that can somebody get me started in the right direction?

Kind regards,

Wizard0