Skip to main content
Inspiring
September 2, 2016
Question

VBA - Writing PDF Form Fields with VBA from EXCEL worksheet

  • September 2, 2016
  • 2 replies
  • 1110 views

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 ?

This topic has been closed for replies.

2 replies

Bernd Alheit
Community Expert
Community Expert
September 3, 2016

May be that the field accepts only numeric values.

Legend
September 2, 2016

Not entirely sure how this connects to Enterprise Deployment. Is this part of your deployment/install/update procedure?