Macro lines to call and sent info to the sequence table
Posted: Tue Jan 22, 2013 8:30 am
by HossamAli
Dears
I need macro steps that fill the Chemstation 4.03 sequence table by my samples info that stored in excel or ASCII file and run the sequence. I tried the macro guide from agilent but also could not figure out how to do it
Thanks in advance
Re: Macro lines to call and sent info to the sequence table
Posted: Fri Feb 01, 2013 3:09 am
by fseipel
See the ChemStation help file on making an import file from Excel. Help|User Interface Reference|Views and Related Dialog box help|Method and run control view|Sequence|Import Configuration (sequence). Click on 'making an import file' for detailed directions. Once you are able to manually import the file, then go to command line at bottom of chemstation screen, try typing in ImportSequenceFromCSV importFilename$,[Suppresslines],MapFile$
I believe an effective way to do this is to have personnel 'log in' samples into a database such as MS access, then build an XML worklist from same, export it, and import results back into Access. Alternately you can do same with the sequences.
Re: Macro lines to call and sent info to the sequence table
Posted: Sun Feb 03, 2013 8:27 am
by HossamAli
thanks