I have an Excel macro that process data and generates individual reports for distribution. The "printing" options are to physically print the individual report as they are created, or populate the reports into a pdf file for mass printing. (Sample code attached).
What I would like to be able to do (at the time of creating the pdf prior to clearing the excel template for the next individual report) is to simultaneously copy the report into a "master" excel file with the same new file and naming convention of the pdf file. Or, save the interim file created in excel for pdf creation, prior to publishing the pdf. Is this doable? If so how/where would I include in the sample code?