Page 1 of 1

Copying Chemstation Calibration table to Excel

Posted: Thu Mar 21, 2013 4:50 pm
by pacerlaser
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!

Re: Copying Chemstation Calibration table to Excel

Posted: Mon Mar 25, 2013 5:08 pm
by Steve Reimer
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.