infopath to excel

K

Kim Paulson

Sorry to bother but I have what I think is a very simple problem. I have
Infopath, 2003, but I do not have Sharepoint. I created a simple yes no
questionnaire using Infopath. This form is not going to be on a website. It
will be used locally on our intranet. What I have found out is that I can
save the forms as form1 from2 and so on. After that I can then export to
excel by selecting all the forms using Infopath. Works perfectly. What I
would like to have happen is when one is done filling out a form then they
would hit submit or save or whatever and the data would automatically export
to excel. The next time a form is filled out then the data would export and
add on to the same excel spreadsheet and so on. I would end up with a excel
spread sheet with all the data from as many forms that were filled out. The
excel spreadsheet would live in the same directory as the Infopath form. You
would think this would be a simple task for Infopath but I cannot find anyway
to do it. Is it really that difficult? Is there not some code I can add.
 

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

Top