I have a database of Infopath forms and an Excel file with a macro to pull all of the data from multiple Infopath files into a spreadsheet using XMLMaps.Import. Now, I would like a way to update the fields in an existing InfoPath form using Excel without creating a new form.
1. Is this possible?
2. What data is needed to make it happen?
3. A sample of vba code if possible.
Thanks.