Advertisement

Copying Chemstation Calibration table to Excel

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

2 posts Page 1 of 1
Hello everyone, I have recently upgraded a computer to Windows 7 from Windows Vista with Chemstation B.04.03. I copy the entire calibration table into Excel where I use a parser macro to calculate the %RSD for my calibration curves. Using the newer computer, however, copies the entire calibration into the A1 cell of my Excel template whereas before it would paste in into several cells that would correlate to my calibration table. The interesting part is if I open up a blank Excel file and copy and paste, it does as it is supposed to and doesn't just use the A1 cell but several cells, which is what I want. Any help with this would be greatly appreciated!
We have recently upgraded to Win7 and E02.02 from older E/D versions. One of the first changes we noticed was that the Excel files created in the new version were not being recongnized by Office 2007 as Excel compatible but were only text files. The reason you see everything in cell A1 is that it sees a delimited text file and is looking for the wrong delimiter.
As a quick fix, I have resorted to opening and saving files with a .xlsx extention.
2 posts Page 1 of 1

Who is online

In total there are 15 users online :: 0 registered, 0 hidden and 15 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 15 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