Just getting my feet wet with this tool. The report templates are a great start, but I’d like to modify them to include a bit more of the detail contained within the Excel worksheets into the PDF file.
For example… I’ve been working with a template I copied from DNS: Blocked - Domains and Users. I’d like to output not only the Overview sheet, but also the BlockedLog and Pivots into the PDF that will go to the client. I found a statement in the script which appears to control this.
I changed it to:
I was thinking this would append the additional two worksheets to the PDF under the Overview section. What it actually did was to only output the last variable to the PDF…. i.e. only the Pivots worksheet appears in the PDF. When I remove the Pivots parameter, it then outputs only the BlockedLog worksheet to the PDF file.
How do you make it so the script appends worksheets to the PDF file?
Best answer by kfranklinView original