My workflow includes a macro that creates a separate workbook for unique sheets on a workbook (among other actions). I need to format this (most importantly, adding a "color" to the first row of headers). I understand this can be done via "render"... how can I do this when the output includes multiple saved spreadsheets?
you can do this via TABLE tool which can then be output via render.
either all of your sheets can be created via a render (you use a union to bring your report snippets together, a layout tool to set the sheet names and output via render) or none of them.
You can create your sheets via render - ie create dummy sheets - and then fill the ones you didn't want rendered using an output data in overwiter sheet mode.
I must admit that this is going directly over my head, and will need to find a few trainings on this. I will play with this a bit before I can respond with a cognitive question and am trying to envision how this workflow would work/where it plugs in to what I have currently. My current output works exactly as needed except for this formatting issue.
@apathetichell, would this replace the current methodology for the output? Ie. remove the output chicklet, insert the table, then render?