Chromatography Forum

Hello

In Excel 2007, I connect to the access database located in the chromeleon directory, I select the samples table, and a table is automatically created with all the samples stored in the database. this is good, but what I want is to see a column for Chlorides amount, one for Sulfates amount, etc...
I made those columns myself in the sequences, but it doesn't help, they dont show when i import the table from Excel.
I tried to make a user-defined column, in the datasource properties. it worked, i could see the colum in the table, but there was nothing in it. (how do i tell the prog that the column i make must use the variables like chlorides amount etc..?)

Hi,
I'm not sure I undestood your problem correctly.

1 "In Excel 2007, I connect to the access database located in the chromeleon directory, .." -You should not access the "Access"-files in the Chromeleon folder directly, it is dangerous. (Actually, the Chromeleon folder should be protectected "by a happy Chromeleon", isn't it?).

2 If you have a Chromeleon Report as the active window, why don't you just do "File>Save as..." and save the report as an Excel file? (And you can also just copy the report and paste it directly into Excel.)

3 If you have a user-defined column, you can edit the report format so that it appears in, for instance, the summary report sheet. Does it not work?

4 Or you can just copy from the different kinds of Chromeleon reports and paste directly into Excel.

(I don't know it is possible to create a Chromeleon sequence by importing an Excel document, like LIMS connections. We just copy columns of data from Excel and and paste columns of sample names and masses into the Chromeleon sequence. We find that workflow simple enough and are satisfied with it.)

I hope this information is of some use. Please clarify further what you want to achieve and what does not work.

Thanks for yout reply!

In the samples list, I have created 2 sequence report columns. Chlorides amount [in ppm], and Sulfates amount [in ppm]. after the analyse and the integration of the samples, I copy the results of those 2 columns and paste it in a Excel sheet. I run two duplicates per sample, so the meaning of the Excel sheet is to quickly calculate the average of the duplicates (+std deviation). When it's done, I print ou t the excel sheet and the sample list and deliver them to my superior for control.

What i want is to be able to directy see the results displayed in the sequence report columns, in Excel, so that I can skip the copy/paste part.

Hi,
In this case I would calculate the average of the duplicates (+std deviation) entirely within the Chromeleon sample report and not involve Excel at all! Saves time!

The Chromeleon programming is very like Excel programming althoug a bit tricky to learn the first steps. Contact your Dionex for help to do it. If you can set upp VBA to do it in Excel, you should be able to do the same in the Chromeleon report.