Thread: CSV output file
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Glenn Ray[_3_] Glenn Ray[_3_] is offline
external usenet poster
 
Posts: 34
Default CSV output file

Here is a non-programmatic solution:

Use the AutoFilter option on your data to select the particular data you
wish to deliver. Manually select all the data visible, copy it, then paste
it to a blank worksheet. Finally, use the "Save As..." function to write
that worksheet data as a CSV file.

-Glenn Ray
MOS Master

"Suzanne" wrote:

Hi

I have made myself a spreadsheet with all the bits I
require for working out some sums to do with work.

The thing is the people collecting the data dont have a
full version of excel. Is there a small program anywhere
which can provide a one page form with a few dropdown
boxes to select values and basically act as a info
collection form to output csv files for me to add to the
main file at work?

It may sound silly but this may be the only way.

Suzy