I am creating a new Excel template to use for my company. I have it formatted nicely, but there is one thing I can't figure out.
Rather than appending a new execution to new rows/columns, I would like it to append to an additional sheet (1 sheet per piece). Is there any way to do this in PC-DMIS? Im using 2023. I know it can be done with the Report window print setup method, but I can't figure out how to make it work with a template.
What kind of information are you wanting in this additional sheet printout? This should be possible with template modifications. I can play around a bit.
What kind of information are you wanting in this additional sheet printout? This should be possible with template modifications. I can play around a bit.
Sounds like they want the entire report as a new sheet in a single excel file for each run of the program.
If you can't figure it out I've got a macro that will combine multiple excel files into a single workbook and another that renames them in sequential order, stolen from the internet of course.