CSV output file

[Suzanne]

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

[Glenn Ray]

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
>

[Tim Williams]

You could always try OpenOffice or something similar (though you'd still
have to build your data entry form).

A simple web page might also work if you have that kind of hosting.
Or a standalone HTA "HTML application" would have access to the local
filesystem and so be able to output the csv data.

Lots of options really, but I can't really think of a "no programming"
solution, if that's what you need.

--
Tim Williams
Palo Alto, CA


"Suzanne" <[email protected]> wrote in message
news:[email protected]...
> 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