-
- Posts: 145
- Joined: Sat Feb 27, 2010 5:27 am
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!
-
- Posts: 693
- Joined: Mon Mar 28, 2005 5:38 pm
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.
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
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.
- Follow us on Twitter: @Sep_Science
- Follow us on Linkedin: Separation Science
