form output

From: Elizabeth (eliz_at_houston.rr.com)
Date: 10/01/04


Date: 1 Oct 2004 06:43:38 -0700

Hi,

I have added a form to the end on my presentation where the viewer can
request more information and the info goes into a txt file. (with help
from this group, I might add) Can I get it to put the information for
each user on one line instead of in a column so that I can easily
import it into Excel when I'm done?

The script I have looks like this:
objTS.WriteLine "Name = " & Me.TextBox1.Text
objTS.WriteLine "Address = " & Me.TextBox2.Text
objTS.WriteLine "City St Zip = " & Me.TextBox3.Text

and comes out like this
Name = Elizabeth
Address = my street
City = Houston

I'd like it to come out like this:
Name=Elizabeth Address=my street City=Houston
Name=Next Person Address=thier street City=some town

can this be done somewhat easily?

thanks,
Elizabeth



Relevant Pages

  • NBC: God Is Looking Down On All This
    ... all around this city, and I am very frustrated because we are not able to ... over here in New Orleans... ... Everybody -- the governor, Homeland Security, FEMA... ... or state request, ...
    (rec.music.artists.springsteen)
  • Re: God Is Looking Down On All This
    ... > people over here in New Orleans... ... > down, the water started flowing again in the city, and started getting to ... > local or state request, ... I've already called for martial law in the city of New Orleans. ...
    (rec.music.artists.springsteen)
  • OT: Interview with the Mayor of New Orleans
    ... Transcript of NOLA mayor Ray Nagin's interview with Garland Robinette ... Have you talked with the president? ... have been all around this city, and I am very frustrated because we ... without local or state request, ...
    (rec.arts.theatre.musicals)
  • Re: Interview with the Mayor of New Orleans
    ... > Transcript of NOLA mayor Ray Nagin's interview with Garland Robinette ... > have been all around this city, and I am very frustrated because we ... > their asses moving to New Orleans. ... > without local or state request, ...
    (rec.arts.theatre.musicals)
  • Re: Who or What is Stopping a Service?
    ... IMAService has the following dependencies: ... Event Viewer showed no stoppage of any related services before the ... The event log reveals that the service is being stopped on request, ...
    (microsoft.public.win2000.security)