VBA - Writing PDF Form Fields with VBA from EXCEL worksheet
Good evening,
I'm writing data from EXCEL to a PDF with formfields. NUMBERS are fine but STRINGS are not acceptet.
Dim AcroExchApp As Acrobat.CAcroApp
Dim AcroExchAVDoc As Acrobat.CAcroAVDoc
Dim AcroExchPDDoc As Acrobat.CAcroPDDoc
Set AcroExchApp = CreateObject("AcroExch.App")
Set AcroExchAVDoc = CreateObject("AcroExch.AVDoc")
Set jso = AcroExchPDDoc.GetJSObject
jso.getField("Text1").Value = text1
If text1 is "1" it works
If text1 is "ABC" I get the error '13'
Someone can help me on this topic ?