Advertisement

Macro lines to call and sent info to the sequence table

Discussions about chromatography data systems, LIMS, controllers, computer issues and related topics.

3 posts Page 1 of 1
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
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.
thanks
3 posts Page 1 of 1

Who is online

In total there are 34 users online :: 0 registered, 0 hidden and 34 guests (based on users active over the past 5 minutes)
Most users ever online was 4374 on Fri Oct 03, 2025 12:41 am

Users browsing this forum: No registered users and 34 guests

Latest Blog Posts from Separation Science

Separation Science offers free learning from the experts covering methods, applications, webinars, eSeminars, videos, tutorials for users of liquid chromatography, gas chromatography, mass spectrometry, sample preparation and related analytical techniques.

Subscribe to our eNewsletter with daily, weekly or monthly updates: Food & Beverage, Environmental, (Bio)Pharmaceutical, Bioclinical, Liquid Chromatography, Gas Chromatography and Mass Spectrometry.

Liquid Chromatography

Gas Chromatography

Mass Spectrometry