VBA multi-report to one pdf
Posted on 2014-08-04
In Excel 2010 I have vba code that loads relecant data into an array that creates a couple hundred reports for individuals with their specific information. (no problem with this).
Initially the request was to "print" these reports - for which the following was successfully used:
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _
Now the request has changed to print all the reports into 1 pdf with pagebreaks for each report. I am totally stumped how to proceed to create a pdf with all the reports. As stated above, these reports are created on the fly and don't exist to attach.
Any input as to how to proceed on changing the output (print) function to pdf is needed.