File renaming in Excel reporting

[[Me...]]

Hello all,
Has anyone tried to change the way of naming an excel file? In default, the excel file is called "name of the measurement plan" + "part number" and I would need to add to the name field "date" and other check boxes depending on the fields given at the CNC start. I am using the standard file "Characteristic.xlt" and "ReportINI". I tried to change the macros in these files, but there is no file response - the name is still the same. Can someone have a solution to this problem? Maybe anyone have a solution to this problem?

[[Am...]]

You should be able to do this in Resources >> "name for output files". I don't export to excel (we export to QC Calc) so I'm not sure if it would be any different but that should work.

[[Ga...]]

Please sign in to view this quote.

We have never been able to find a way to customize the Excel output name either. We use the "name for output files" options for a few different reports, but haven't found a way to modify .xls output filename..

[[An...]]

I have the same issue. I can not rename the excel file trough macro change.

I'm thinking to try to save "TXT" file with "name for output files" so you can rename the file as you want, then create an Excel Macro that copy name and contents in new Excel File.
This is just on my mind. I didn't do that yet but i hope is an help for all of us. 😉

[[Br...]]

You can add a line at the end of the main macro to "save as" whatever name you want, and whatever file you want. Something like:

ActiveWorkbook.SaveAs Filename:=({File path goes here})