View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
 
Posts: 829
Default Excel And Notepad

"Bob" wrote:
Have an Excel Spreadsheet that I saved in CSV format.
The program that imports and uses it, manages to import most
of it correctly, but messes up on some of the cells.
If I look at it in Notepad, or Notepad++ it looks 100% fine.
So, I thought I would like to try importing into the program
directly from Notepad or Notepad++ [...].
From what I can see in their Save As options, neither seems
to allow Saving as a CSV.

[....]
Does anyone know if it is possible to save a Notepad or
Notepad++ file as a CSV ? How ?


In the Notepad Save As dialog box, select All Files in the "Save as type"
drop-down list. Then enter the file name, complete with the file extension
".csv".

But that might not solve your problem. Or it might not be necessary.

What language or application is "the program that imports and uses" the CSV
file?

How would you "try importing into the program directly from Notepad"?

What syntax in the CSV file save from Excel causes problems for the "the
program that imports" it?

If the "the program that imports" the file is another Excel workbook, and if
you intend to use VBA to invoke Notepad to "import into the program
directly" somehow, you could simply write your own macro to parse the CSV
file directly using the Line Input# statement.