DDE File Creation on New Job

DDE File Creation on New Job

I'm still very new to this DDE reporting. I just figured out how to make it work and put results where I want them. Is there a way to have it create a new Excel file for each new job?

Right now I've been saving all the standard reports to a folder, appending the file name with a job number input from the runtime Customer Data.

I would like to have an Excel report that has all the parts inspected from a job, with the job number appended to the Excel file name. Then when we start a new job number, a new Excel file would be created. Is there a way to do that?