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
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