I've searched...and I've googled. I have an infopath form that I'd like to fill out certain fields from excel. The form is used as an approval response. I can get it to open just fine by creating an infopath object in vba. Now, i want to set field10 to be a value from an index in an array. Please help. Also, this form has a repeating table. I'd like to dynamically fill it out as well and add rows and such. Thank you in advance. I'm very new to infopath.
Sub infForm()
Dim infopathApp As Object
Set infopathApp = CreateObject("InfoPath.Application")
infopathApp.XDocuments.NewFromSolution ("C:\Users\b\Desktop\thisApproval.xsn")
infopathApp.SelectSingleNode("/dfs:my:myFields/my:field10").Value = "Test"
'infopathApp.getdom("form1").SetProperty ("group2")
End Sub
Opens up the infopath document just fine.