Output to a text file.

[megnin]

How can I get output from combo box selections to populate a plain text file?

I need a string of comma delimited text as output from several combo boxes.

Thanks.

 

[JohnG]

First you need to open the text file for output in the form :-
Open pathname For mode [Write] [lock] As [#]filenumber [Len=reclength]

The take data from a textbox's to a variable with comma delimiter.
Tempvar=textbox1.value & ", " & textbox2.value & ", " & textbox3.value etc

Finally write variable
Write #1 Tempvar

Don't forget to close file at the end.

 

[megnin]

That's a bit over my head. I'm not a programmer. I do well to get the combo boxes to do what I want

Additionally I need this to be totally automated because it's going to be used in our South American region by people running Excel 5.0/95.

I'm not sure if the text file is my only option. If I'm lucky I can use a text box. I'm still waiting for specs on the format the output has to be in.

If they can cut and past the output into their tool then I should be able to use a text box.

They wanted me to put the entire list in one cell but Excel 5.0/95 only supports 255 characters in a single cell.

Any advise is greatly appreciated!!

 

[Joe4]

I'm not sure if this will help you, but I did something a little like this. What I did was I had a command button for them to push when they were done. The command button would take the values entered on sheet one (that had combo boxes and manual entries) and create the data file on sheet two, inserting commas where necessary. Then it would save sheet two as a comma separated file.

Either way, you'll porbably have to use a little VBA.

 

[megnin]

That sounds like just the ticket. How did you get it to save as a comma separated file?

 

[Joe4]

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.