Re: form output

From: David M. Marcovitz (marcoNOSPAM_at_loyola.edu)
Date: 10/01/04 

Date: Fri, 01 Oct 2004 07:03:31 -0700

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/
eliz@houston.rr.com (Elizabeth) wrote in 
news:999d969b.0410010543.1993a8fa@posting.google.com:
> 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

  • Re: Spreadsheet Into Word File
    ... "Elizabeth de V." <Elizabeth de ... > inserts the binary code of the Excel file which does me NO ... On the first insertion, Word told me that it had to ... install some sort of "conversion tool", ...
    (microsoft.public.office.misc)
  • Re: form output
    ... In article, Elizabeth wrote: ... > import it into Excel when I'm done? ... Name, Address, etc. column headers out the first time the output file's opened, ... Steve Rindsberg, PPT MVP ...
    (microsoft.public.powerpoint)
  • Re: Need help with creating a combo box with a drop down arrow
    ... Debra Dalgleish has some instructions with nice pictures at: ... Elizabeth wrote: ... > I'm working in Excel with a fom that I would like to create combo box where I ...
    (microsoft.public.excel.misc)