form output

[Elizabeth]

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

 

[David M. Marcovitz]

Sure. Each WriteLine, writes a new line, but each & puts things together
on the same line, so you could do something like this:

objTS.WriteLine "Name = " & Me.TextBox1.Text & " Address = " &
Me.TextBox2.Text & " City St Zip = " & Me.TextBox3.Text

Note a couple of things. This is all one big long line so if the
newsreader breaks it up just keep it all on one line. Also, note the
additional ampersands (&) plus the additional spaces. This might need a
little work to get Excel to read it easily (like using TABs instead of
spaces).

--David

--
David M. Marcovitz
Director of Graduate Programs in Educational Technology
Loyola College in Maryland
Author of _Powerful PowerPoint for Educators_
http://www.loyola.edu/education/PowerfulPowerPoint/

(e-mail address removed) (Elizabeth) wrote in