gmem9
MIS
- Mar 26, 2009
- 3
Hi,
I'm new to vbscript...I'm using vbscript to capture user data from an InfoPath form and send the data to a new row to an existing excel document. I've managed to figure out how to send hardcoded data from vb to excel, but I can't figure out how to send the forms data to excel. Any idea? I've searched this forum, but can't find anything...
Steps:
- Fill out form
- Click Submit
- Data gets sent to an existing excel file
- Excel file is updated with a new row, saved, and closed automatically.
Thanks!
I'm new to vbscript...I'm using vbscript to capture user data from an InfoPath form and send the data to a new row to an existing excel document. I've managed to figure out how to send hardcoded data from vb to excel, but I can't figure out how to send the forms data to excel. Any idea? I've searched this forum, but can't find anything...
Steps:
- Fill out form
- Click Submit
- Data gets sent to an existing excel file
- Excel file is updated with a new row, saved, and closed automatically.
Thanks!
