Send form input data to a spreadsheet

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data collection via email, via spreadsheets, not forms 0
Using Forms to Export Data from an Access Table to an Excel Spreadsheet 1
send form as pdf from access with the click of 1 button? 0
Need Solution for printing form data 3
Exporting form data to an existing Excel spreadsheet 1
Retrieve data from company intranet page 8
ASP Script to Send an email which generates into a HTML format 2
How do I Take Data from XL Form and input to spreadsheet? 3

Top