What I actually did was create the file on sheet 2 and save it as a ".prn" file (text file).
For example, in cell A1, I created a string (inserting the commas where necessary) something like the following:
[combo box 1] & "," & [combo box 2] & "," & etc.
I then would repeat it for cell A2, A3, etc. until I have completed writing all of my data. Then I saved it as a ".prn" file which, because I inserted the commas, is really a Comma Separated Value file.