Re: Saving As .CSV

Tech-Archive recommends: Fix windows errors by optimizing your registry

I'm such an idiot. I didn't scroll down through the menu. I thought the
five options I mentioned were all there were. Arrgh. Thanks for the help,
anyway.

"Dave Peterson" <petersod@xxxxxxxxxxxxxxxx> wrote in message
news:4609F24A.E32E1355@xxxxxxxxxxxxxxxxxxx
It's the one that looks like:

"CSV (Comma delimited)(*.csv)"



Grant wrote:

Would you care to share exactly WHICH option allows me to save it to
.csv?
Because, as I told Bob, when I "Save As," I see no comma delimited
option,
only Text (Tab Delimited) and some others. Thanks.

"Dave Peterson" <petersod@xxxxxxxxxxxxxxxx> wrote in message
news:46099CA5.6445AD9F@xxxxxxxxxxxxxxxxxxx
Actually, there is a "CSV (Comma delimited)(*.csv)" option.

It just doesn't use the same rules as what you want.

(Or your rules don't use the same rules as what MS wants...)

Grant wrote:

Thanks Dave, that first one did the trick. What I don't understand is
why
there simply isn't an option to save as Text-Comma Delimited rather
than
Text-Tab Delimited. Anyhoo, I got what I need. Thanks again.

Grant

"Dave Peterson" <petersod@xxxxxxxxxxxxxxxx> wrote in message
news:46096868.90F04681@xxxxxxxxxxxxxxxxxxx
You could use a macro and write code and have complete control over
what
you
write.

Here are three sites that you could steal some code from:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly:
http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

Grant wrote:

Hello, here's the situation: I downloaded an .xls file from my
broker
and
opened it in Excel. The original file was delimited by commas and
I
had
to
choose comma delimited in order for Excel to display it in
columns/rows
correctly. I made some changes to the file, then saved it with a
new
name.
The problem is, I can find no way to save it as a comma delimited
file
again. Saving it as a Workbook places quotes around the commas and
creates
spacing between text (when I view it in Wordpad), and saving it as
a
Text
File (Tab delimited) does just that--makes it TAB delimited, not
comma
delimited. I just need my file to be a comma delimited text file
again,
like it was originally. Any ideas?

Thanks in advance,

Grant

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson


.

Relevant Pages

  • Re: Cannot lock project
    ... "Dave Peterson" wrote in message ... Yes I've also read similar and don't normally save from the VBE. ... though couldn't be fixed by saving changing IsAddin to false, locking, then ... > manually I get a reminder, wehe I close Excel. ...
    (microsoft.public.excel.programming)
  • Re: Where does MS Vista store xslx files opened directly from Inte
    ... "Dave Peterson" wrote: ... saving it to disk before using it), worked with it, saved to disk (instead of ... saving as...), closed Excel, and now I can't find the file anywhere. ...
    (microsoft.public.excel.misc)
  • Re: Saving As .CSV
    ... Grant wrote: ... opened it in Excel. ... Saving it as a Workbook places quotes around the commas and ... Dave Peterson ...
    (microsoft.public.excel)
  • Re: Saving As .CSV
    ... Grant wrote: ... I tried Workbook and Text. ... opened it in Excel. ... Saving it as a Workbook places quotes around the commas and creates spacing between text, and saving it as a Text File does just that--makes it TAB delimited, not comma delimited. ...
    (microsoft.public.excel)
  • Re: File corrupts when saving under a different name - xl2000
    ... corruption when Excel is not properly used. ... "Dave Peterson" wrote: ... Are you asking if there is a kb article about converting an Excel system to ... and, perhaps, magnify over time of saving with a new name. ...
    (microsoft.public.excel.misc)