How do I create a comma delineated xls file to a comma delineated.

[Guest]

I need to be able to create a comma delineated ascii file. I have the data
already set up on an excel spread sheet. I cannot use a csv file format.

 

[JE McGimpsey]

it would be helpful if you gave more info, but you might find something
you can use here:

http://www.mcgimpsey.com/excel/textfiles.html

 

[Mark]

Hi,

You could try the save as option and select the file type
as CSV MS-dos but you must have only one sheet in the
workbook to do this. also, it is still Excel oriented, not
a true text file.

You will need a macro to create and write to a text file.
It needs to use the createobject reference.

See my webpagetablemaker.xls at
http://www.geocities.com/excelmarksway

it creates sheet1.htm page of the data in the excel sheet.


Send me a sample sheet of what you need to
(e-mail address removed)

and as much info as possible.

- - mark

 

[Myrna Larson]

also, it is still Excel oriented, not

a true text file.

Could you please explain what you mean by the above?

If it has to do with clicking on such a file and having Excel open it rather
than, say Notepad, that's a consequence of your Windows File Associations. It
has nothing to do with the format of the file.

 

[Mark]

Yes, you are absolutely correct.

-----Original Message-----

Could you please explain what you mean by the above?

If it has to do with clicking on such a file and having Excel open it rather
than, say Notepad, that's a consequence of your Windows File Associations. It
has nothing to do with the format of the file.
.