Excel VBA - Create .csv file from Worksheet

[brxndxn]

I would like to create a button in Excel that saves a worksheet in the same Excel workbook named "Worksheet1" to a csv file. I also want it to prompt for the filename and location..

What is a nice pretty way to do this?

I'm not the best at creating new VBA scripts, but I can understand them..

 

[esun]

Can't Excel already do this from the File -> Save option (select .csv as the file type)?

 

[drebo]

Yeah, File->Save As..., set type to .csv.

 

[brxndxn]

Originally posted by: drebo
Yeah, File->Save As..., set type to .csv.

I want to do this from a button I imbed in the worksheet... Click the button and instantly c:\output.csv appears.. while the current xls file stays open..

 

[Duwelon]

Try recording a macro of yourself saving it as a CSV file. In Office 2007 it creates this code:

ActiveWorkbook.SaveAs Filename:="C:\Users\Aaron\Documents\Book1.csv", _
FileFormat:=xlCSV, CreateBackup:=False

I'm assuming you know how to create the button and make it work so i'll stop here.