-
- Posts: 48
- Joined: Tue Dec 14, 2004 5:21 pm
somebody may post this kind info. before.
i am looking for samples of macro that for chemstation controlling the 1100 LC system.
what i need:
the daily workload in my lab is mainly the screening of unknown compounds through a set of columns with different mobile phases, no matter what kind the compound it is, the screening process is fixed. that is, it will go through all columns with different but fixed sequence of flow programs.
the hardware consists of two 12-port valves served as binary mobile phase selectors, and one 6-port valve served as column selector, so theoretically it could be 144 different flow program with 6 columns, which is 864 runs for just one sample for the whole screening. practically we only need to run about 40 runs total with 25 min. each so total run time is 1000 min., which is about a whole day and overnight.
i have looked at the macro guide from agilent and the ucl directory from the chemstation CD, there are some examples there that run like this way:
first generate the sequence table from excel, then import it into chemstation then run it automatically.
at current stage i am not very proficient at either excel macro and chemstation macro, so i am looking for help here that someone may have written this kind of things already that i can take as my start point and reference.
my ideal way would be, to run the excel first that asks user to type in the sample ID and vial position, then it will automatically generate the whole spreadsheet of flow program sequence, since the order of flow sequence is fixed, only sample info is variables.
then, i need the chemstation macro to import the CSV file from excel into chemstation sequence and execute. the one in Chemstation CD is for 96 well format only(i beleive), i only run autosampler with std. hplc 2 ml vial format.
the extra question is after the sequence is finished, how to put together all 40 chromatogram traces to the screening check, all we need to see is just under what flow gram there is some separations. then we can go from there for further development.
thanks in advance, please at least tell me where to look at. i had worked before on labview and in 2 months get it run well, so i figure this chemstation macro is about the same difficulty level.
i am looking for samples of macro that for chemstation controlling the 1100 LC system.
what i need:
the daily workload in my lab is mainly the screening of unknown compounds through a set of columns with different mobile phases, no matter what kind the compound it is, the screening process is fixed. that is, it will go through all columns with different but fixed sequence of flow programs.
the hardware consists of two 12-port valves served as binary mobile phase selectors, and one 6-port valve served as column selector, so theoretically it could be 144 different flow program with 6 columns, which is 864 runs for just one sample for the whole screening. practically we only need to run about 40 runs total with 25 min. each so total run time is 1000 min., which is about a whole day and overnight.
i have looked at the macro guide from agilent and the ucl directory from the chemstation CD, there are some examples there that run like this way:
first generate the sequence table from excel, then import it into chemstation then run it automatically.
at current stage i am not very proficient at either excel macro and chemstation macro, so i am looking for help here that someone may have written this kind of things already that i can take as my start point and reference.
my ideal way would be, to run the excel first that asks user to type in the sample ID and vial position, then it will automatically generate the whole spreadsheet of flow program sequence, since the order of flow sequence is fixed, only sample info is variables.
then, i need the chemstation macro to import the CSV file from excel into chemstation sequence and execute. the one in Chemstation CD is for 96 well format only(i beleive), i only run autosampler with std. hplc 2 ml vial format.
the extra question is after the sequence is finished, how to put together all 40 chromatogram traces to the screening check, all we need to see is just under what flow gram there is some separations. then we can go from there for further development.
thanks in advance, please at least tell me where to look at. i had worked before on labview and in 2 months get it run well, so i figure this chemstation macro is about the same difficulty level.
