Saving an excel file with vba under in csv format

**stingtunny** · 08-24-2007, 03:02 PM

Hello all,

pretty new to excel programming so please be gentle!

I was wondering whether it was possible to save an excel file containing vba code in .csv format. I don't want to be able to use or see the vba in the .csv format only the cell data.

I usually save this through several windows and directories and wanted to set up a command button to do the job with one click.

Thanks.

**Dav** · 08-24-2007, 04:24 PM

You can save any file in the csv format. it it just the values in the cells separated by commas. It looses any kind of formatting, formulas and VB code.

Is this what you want to do? resaving it as an excel file will not recreate the vba code etc is this what you want?

You could set up code to save as a csv file.

Regards

Dav

**stingtunny** · 08-24-2007, 04:41 PM

Just need to save the data on an excel spreadsheet to .csv format. I want to set up a command button to do this with one click. I just don't know if the vba will corrupt the data when it's opened in .csv format.
We change recipes at work on excel but the machines that read the recipes only read .csv, will the vba just be ignored or doesn't it translate?

Cheers.

**Dav** · 08-24-2007, 05:08 PM

a csv file just saves one sheet no formating no formulas and no vba

Try it! save the file as an excel file first the you have not lost anything, and then save as a csv file, close it and open it and you will see what it looks like

Regards

Dav