Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CSV output file
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
CSV output file
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
output to the same line in a Text file? | Excel Discussion (Misc queries) | |||
Need Help With Loop That Creates Output File | Excel Discussion (Misc queries) | |||
Open a print output sent to file | Excel Discussion (Misc queries) | |||
How would I select output to a file or Debug? | Excel Programming | |||
VBA help to output a file | Excel Programming |