download to be able to save files as CSV in Excel?

G

Guest

Clicking Save As in Excel 2002 does not give me the option to save as CSV so
I guess I have to download that ability but I can't find it.

Basically I want to convert a column of words in Excel to a text list with
commas in between without tabs or paragraphs.

Thanks,
BrianH
 
C

Craig

Try this

/code
Sub SaveAsCSV()
FullFileName = Application.GetSaveAsFilename("", "CSV (Comma
delimited)(*.csv),*.csv", 1, "Save As *.csv")
If FullFileName <> "False" Then
ActiveWorkbook.SaveAs Filename:=FullFileName, FileFormat:=xlCSV
End If
End Sub
/code

Craig
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save as CSV not saving the same from Excel 2007 then in Excel 2003 1
Excel CSV Files; Creating Of 3
.csv Commas ? 2
How to save files in the formats of *.csv(MS-DOS) in Excel 2003 2
Unicode in CSV files 5
CSV to Excel 3
*.csv format change if .xlt save as .csv in Excel 2007 1
Convert csv to Excel files 1

Top