Excell 2007 to CSV file in Windows XP/Prof

By radson ·
I need to store a column of values from an Excel 2007 worksheet into a row of values separated by commas in a .CSV file. I can then attach this file to an e-mail and eventually use it as input to a MATLAB simulation. Many sources have suggested that to save an Excel file to a .CSV file, I must "Save AS CSV". In my old Excel 2000 I am able to "Save As Space Separated Text". If I then open this file using Notepad, I get values but no commas. In Excel 2007, the "Save As" options do NOT include any CSV formats, nor do the "Save As Type" selections in the window that follows. On the other hand, If I copy and paste a spreadsheet selection onto a notepad window, I get the same results as if I "Save As" a .txt file in Excel 2000. None of the above automatically separates the values with commas in a row of text in Notepad. Since I have thousands of values, I need to write a VBS program to do this. Any thoughts?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Related Discussions

Related Forums