creating csv file at runtime

I was just enquiring if anybody know how to create csv files in excel at run time. I have a feeling it's just a matter of open up an excel object and then 'saving as' a csv file. Im not sure though so if any one can help it would be much appreciated.

Just remembered. I would also like to know how to append an attatchment to an outlook message object.

Thanks again
:cool:

You just want to create a comma delimeted file when an app loads is it ?

yeah, when the form loads up i need to create a csv file and populate it. Im just not sure what syntax to use with the "Saveas" method of the worksheet object. See i've created a new instance of excel and am just going to try and save as csv file.

I would also like to know the syntax to append an attatchment to an outlook mail object.

Any help would e much appreciated.

Do you need to do this in VB or in Excel using VBA?

I would think VB would be easier because you can just open a file for output and then save each line of the CVS with a print statement.

If you need to do this in Excel turn the macro recorder on and then do a couple of operations you want to do in your program and then save as CVS file, then take a look at the macro that was recorded.

Yeah as steve said, all you do is open up the file for output and print to it and put commas between the fields

' -- Tell the browser the data is a Comma Separated Values List (CSV)
response.ContentType="application/csv"
' -- Tell the browser to associate a file name with the data
Response.AddHeader "Content-Disposition", "filename=anytext.csv;"

Then use response.write to fill a cell, writing a comma to indicate to jump to the next column. Use response.write vbnewline to move to the next row.