Using Excel to comand PDF files to merge

%3CLINGO-SUB%20id%3D%22lingo-sub-2056347%22%20slang%3D%22en-US%22%3EUsing%20Excel%20to%20comand%20PDF%20files%20to%20merge%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2056347%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20project%20where%20I%20need%20to%20generate%20some%20adobe%20PDF%20files%20(or%20packages)%20which%20contain%20multiple%20other%20PDF%20files.%20The%20best%20adobe%20could%20do%20was%20tell%20me%20about%20their%20'combine%20pdf'%20tool.%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20anyway%20in%20excel%20or%20by%20using%20VBA%20I%20could%20command%20say%20a%20list%20of%20file%20names%20or%20paths%20to%20combine%20into%20one%20PDF%20document%3F%3C%2FP%3E%3CP%3EI%20have%20to%20do%20this%20around%20100%20times%20for%20a%20minimum%20of%2011%20constituent%20parts%20each%20time%20so%20it's%20really%20not%20feasible%20to%20do%20manually%20but%20I%20have%20some%20excel%20ground%20work%20done%20already%20to%20audit%20every%20file%20there%20is%20so%20just%20hope%20this%20can%20be%20used%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2056347%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have a project where I need to generate some adobe PDF files (or packages) which contain multiple other PDF files. The best adobe could do was tell me about their 'combine pdf' tool. 

Is there anyway in excel or by using VBA I could command say a list of file names or paths to combine into one PDF document?

I have to do this around 100 times for a minimum of 11 constituent parts each time so it's really not feasible to do manually but I have some excel ground work done already to audit every file there is so just hope this can be used

0 Replies