I'd start a new workbook
Then back to the original worksheet
Edit|Copy columns C:D
Edit|Pastespecial|values into A1 of the new worksheet in the new workbook

Save this file as the .csv file

Close the new workbook.

========
Another option that may work for you:

Put a formula like this in E1:
=c1&","&d1
and drag down

Then copy this column and paste into NotePad. Save that as a .CSV file.

Depending what's in those fields, you may want to add double quotes, too.



Ephraim wrote:

Hi,

I have a small spreadsheet with 20 check boxes in Column A (A1-A20).
They are all linked to corresponding cells in Column B which give TRUE
or FALSE depending on if they are checked or unchecked. No problem
there.

I have the corresponding check boxes displaying "Computer 1" in cell
C1 and so on down to C20
i.e. Formula in C1 is =IF(B1,"Computer 1","")

Once the user has checked/unchecked as required then I'd like to be
able to save Column C1:C20 and Column D1:D20 to a csv file called
"UserInput.csv"

Thanks
Ephraim

--

Dave Peterson