Reports / Excel File

[[Hu...]]

Hi, I am running Calypso 5.8 and would like to know how to make the print of the reports after a run go to a select directory and is it possible to make the report export into an excel file.
Thanks
Jim

[[Da...]]

Jim, that's been covered.
Here is the link to Mark's post -> viewtopic.php?f=13&t=802&hilit=excel#p5612

[[Hu...]]

Thank You Medic

[[To...]]

The "how to" that Mark created is awesome but it is limited to a specific part at generic location. How would you save the basic excel report in a specific location, i.e. customer's folder of results?

The helpdesk has a solution to rename the characteristics table file with .xls under the Name for Output Files section. Unfortunately, that method does not create a nice looking format.

[[De...]]

I have not needed to do this, but it would certainly be possible to add vba code to an excel file that would create a new excel file and copy the data into it.

So you should be able to create an excel file that used the existing data that was passed in from Calypso to create a path and filename, and then create a new excel file at the new location and copy the existing data to the new file.

I think you would want to have a different copy of the excel file for each program though either way, since otherwise two programs might finish at the same time and try and access a file that was already in use which would most likely cause an error.