You can open a COPY of anyone of these with Notepad to learn more about the macro language. DO NOT OPEN a.MAC file in hpchemmsexe. First make a copy of the file into a temp directory and then open the copy. If you have an Agilent ChemStation, the directory may be msdchemmsexe. Diablo has written several different sequence summary macros for the Agilent ChemStation. These macros typically create comma-delimited text files containing a client-specified summary of the results for all the runs in a sequence. These macros have also been configured to 'poke' sequence summary results into Microsoft Excel.

• Agilent Chemstation Macros Software
• Agilent Msd Chemstation Macros
• Agilent Chemstation Software Manual

I am currently working as an analyst using an Agilent GC-MS.

I was wondering how I could learn how to write macros for automating some of the work in terms of compiling and organizing data in different formats. Are there ways I can learn this stuff for free? Can this knowledge be applied elsewhere, and is it a good/lucrative skill to have?

Download Bauer Bodoni Roman For Free, View Sample Text, Rating And More On Fontsgeek.com. Bodoni roman free font. Download 10,000 fonts with one click for just $19.95. The Ultimate Font Download is the largest and best selling font collection online. The fonts are licensed for personal and commercial use. Download 10,000 fonts today. Instant and unlimited access to 10,000 fonts. Click Here For Details.

Agilent Chemstation Macros Software

There is a lot of doom and gloom around the chemistry field, and I thought I would hit two birds with one stone - make my work more efficient and improve some processes, as well as expand my skill-set.

Izzy,

Agilent Msd Chemstation Macros

I have faced situations where I have had to export data automated and routinely from chemstation software. My first question is which version of chemstation are you running? There is a difference between MSD Chemstation and Chemstation (i.e. for HPLC etc.). Also, I have found it to be much more efficient to use chemstation's built in capabilities to export data and then manage the data in other ways. I have a set up where every time my GCMS runs, chemstation runs a series of macros that basically export all the data about the run into a MySQL DB, and execute a bunch of housecleaning stuff. Then it is easy to manipulate the data. In MSD Chemstation's data analysis program you can create a custom report which allows you to generate a CRD file which can be opened in Excel, or in my case I use an XLS to CSV converter and parse out all of the ____ in the CRD file. At this point, one can simply create an Excel sheet that uses the csv file as it's datasource. This can be formatted any way Excel is capable. This will work, but it is not the best way. Better to import the csv file into a database. Now you have power and manipulate the data in any direction imaginable. Anyway, I might be able to help with more information about your system. I use both types of chemstation. I am not an expert in the macro language. I have found documentation lacking on it, and I have no time to take a class. I have had some success reverse engineering the existing macros (chemstation seems to run entirely on macros). Really though, I like to get the data away from chemstation as fast as possible. It's just old technology that is only good for interfacing the the instruments. IMHO

Good Luck..

Agilent Chemstation Software Manual

Dave