Send form input data to a spreadsheet

  • Thread starter Thread starter Marc
  • Start date Start date
M

Marc

I use a form to capture an employee's Name, job location, employee #
and enter it on a slide which will be printed.
(the code's not shown here) - this isn't the problem...

Currently, I also export this info to a .txt file:
Open "C:\Test.txt" For Append As #1
Print #1, userFirstName, userLastName, Station, EmpNum, Now, vbCrLf
Close #1

That works OK, but I'd rather to send/append it to an .xls,
which would make it much easier to manipulate (sort).
Can this be done? Alternate solutions?
THANKS
 
I use a form to capture an employee's Name, job location, employee #
and enter it on a slide which will be printed.
(the code's not shown here) - this isn't the problem...

Currently, I also export this info to a .txt file:
Open "C:\Test.txt" For Append As #1
Print #1, userFirstName, userLastName, Station, EmpNum, Now, vbCrLf
Close #1

That works OK, but I'd rather to send/append it to an .xls,
which would make it much easier to manipulate (sort).
Can this be done? Alternate solutions?
Click to expand...

Yes ... have a look here and at the other FAQs in the same general area:

Automate Excel from PowerPoint. Automate PowerPoint from Excel. And so on.
http://www.pptfaq.com/FAQ00368.htm

Another approach is to make a CSV file from PPT rather than plain text; CSVs
open directly into Excel pretty much as though they came from XLS files.

Print #1, Chr$(34) & userFirstName & Chr$(34) _
& "," _
& Chr$(34) & userLastName & Chr$(34) _
& "," _
& so on & so forth ...
 
Back
Top