export multiple analysis in one file

[ACSolutions]

Is there a possibility to export every new result in the same exportfile and keeping the result from the previous export in this file. Otherwise I will have to make an excel macro that extracts the data from the export file, adding the results it into a new file. In EZChrom the export of the same method ends up in the same export file.

[Daniel Mentlik]

Hello,
it depends on the export format. For example for the text format, this can be achieved by:

• setting a desired name for the exported file. Without the name defined, the export will be named according to the chromatogram exported.
• selecting the Append option

It may also be useful to select the "Full Format" option, as it will preface each row in the exported file with the information on the chromatogram and signal from which the row originates.

Unfortunately, for the Excel format this is not possible - even with Append option the Excel file will overwrite the content (tabs are attributed based on content, not by source). You may achieve appending to excel by either exporting to txt file and calling a postrun import of exported file into Excel, or by running a VBA macro which renames the tabs upon export. Both actions may be triggered by post-run options so that they happen simultaneously with the export (for more details please see for example this thread).

Best Regards,
Daniel

[ACSolutions]

Hi Daniel,

Thanks. I tried with the .txt but didn't check the append option. It's a life saver!