Values from Excel to PDF Form Fields

[Pap12]

Hi All,

I have come across a requirement wherein I need to fill up a secured PDF form with details in Master Data sheet.

I have scanned across forums and could find some references to this and the one I am using is from below link.
http://www.myengineeringworld.net/2013/10/read-and-write-pdf-forms-from-excel-vba.html

I have also managed to get the form field names of this secured pdf, however, I am unable to search these form field names in pdf to update the data from excel.

I have attached the first page of pdf and the complete code.

'....
'Unable to search form fields using below...
strFieldNames(1) = "form1[0].#subform[0].q1a_LastName[0]"
strFieldNames(2) = "form1[0].#subform[0].q1b_FirstName[0]"
strFieldNames(3) = "form1[0].#subform[0].q1c_MiddleName[0]"
strFieldNames(4) = "form1[0].#subform[0].q2_NameofCompanyorOrg[0]"
strFieldNames(5) = "form1[0].#subform[0].q3b_StreetNumber[0]"
strFieldNames(6) = "form1[0].#subform[0].q3d_City[0]"
strFieldNames(7) = "form1[0].#subform[0].q3f_Country[0]"
strFieldNames(8) = "form1[0].#subform[0].q3e_State_Province[0]"
strFieldNames(9) = "form1[0].#subform[0].q3g_ZipPostalCode[0]"
strFieldNames(10) = "form1[0].#subform[0].q3i_EmailAddress[0]"
strFieldNames(11) = "form1[0].#subform[0].q3j_FEIN[0]"
[\CODE]

Thank you for your help in advance... Hoping to get some solution to this.