I have a current VBA script that loops thru every recordset and export 7 reports into 7 pdfs with a unique file name derived from the "CustomerID" field in the recordset...
so 1000 records means I have a folder with 7000 pdfs all with unique filenames.
now I need to merge every 7 into 1 final pdf
so...
example 1:
Cust1-pg1.pdf
Cust1-pg2.pdf
Cust1-pg3.pdf
Cust1-pg4.pdf
Cust1-pg5.pdf
Cust1-pg6.pdf
Cust1-pg7.pdf
needs to merge in to one pdf called... Cust1.pdf
example 2
Cust99-pg1.pdf
Cust99-pg2.pdf
Cust99-pg3.pdf
Cust99-pg4.pdf
Cust99-pg5.pdf
Cust99-pg6.pdf
Cust99-pg7.pdf
needs to merge in to one pdf called... Cust99.pdf
I have been successful at creating a script the merges properly except the file locations are hardcoded into the script and it does not loop thru the recordset.
when I try to make the file location a variable and then loop thru the recordset, all kinds of error occur...
anyone have any ideas, suggestions or scripts they can share?
I'm fairly new to this VBA world so any insights would be greatly appreciated.
thank you in advance
so 1000 records means I have a folder with 7000 pdfs all with unique filenames.
now I need to merge every 7 into 1 final pdf
so...
example 1:
Cust1-pg1.pdf
Cust1-pg2.pdf
Cust1-pg3.pdf
Cust1-pg4.pdf
Cust1-pg5.pdf
Cust1-pg6.pdf
Cust1-pg7.pdf
needs to merge in to one pdf called... Cust1.pdf
example 2
Cust99-pg1.pdf
Cust99-pg2.pdf
Cust99-pg3.pdf
Cust99-pg4.pdf
Cust99-pg5.pdf
Cust99-pg6.pdf
Cust99-pg7.pdf
needs to merge in to one pdf called... Cust99.pdf
I have been successful at creating a script the merges properly except the file locations are hardcoded into the script and it does not loop thru the recordset.
when I try to make the file location a variable and then loop thru the recordset, all kinds of error occur...
anyone have any ideas, suggestions or scripts they can share?
I'm fairly new to this VBA world so any insights would be greatly appreciated.
thank you in advance