Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel And Notepad
Hello,
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. A bit surprised, as I thought a CSV is pretty much a text file, so CSV Saving should be easy from Notepad, or Notepad++ which certainly has a lot of other Save options, though. Does anyone know if it is possible to save a Notepad or Notepad++ file as a CSV ? How ? Thanks, Bob |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel And Notepad
On Sat, 16 Nov 2013 09:19:55 -0500, Bob wrote:
Hello, 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. A bit surprised, as I thought a CSV is pretty much a text file, so CSV Saving should be easy from Notepad, or Notepad++ which certainly has a lot of other Save options, though. Does anyone know if it is possible to save a Notepad or Notepad++ file as a CSV ? How ? If it displays as a CSV file in Notepad, then that's what it will save as. -- Steve Hayes from Tshwane, South Africa Web: http://www.khanya.org.za/stevesig.htm Blog: http://khanya.wordpress.com E-mail - see web page, or parse: shayes at dunelm full stop org full stop uk |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
From OP: Excel And Notepad
Hello,
Thank you all for the help. Very appreciated All set now. Bob ------------------- On 11/16/2013 9:19 AM, Bob wrote: Hello, 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. A bit surprised, as I thought a CSV is pretty much a text file, so CSV Saving should be easy from Notepad, or Notepad++ which certainly has a lot of other Save options, though. Does anyone know if it is possible to save a Notepad or Notepad++ file as a CSV ? How ? Thanks, Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening Notepad from Excel | Excel Programming | |||
Notepad to excel | Excel Discussion (Misc queries) | |||
notepad to excel | New Users to Excel | |||
notepad to excel spreadsheet | Excel Programming | |||
notepad in excel | Excel Programming |