Excel to PDF VBA writing a code to indicate new line within same box

[cskelk]

Hello,

I have Data from Excel, that I am writing VBA to insert Data onto a fillable PDF Box Here is the specific code referring to my Problem:

Application.SendKeys "Academy ID - ", True
Application.SendKeys AcademyID, True
Application.Wait Now + 0.00001

'Need to insert code so I can "Enter" and create new line

Application.SendKeys "Weapon Serial Number - ", True
Application.SendKeys WeaponSerial, True
Application.Wait Now + 0.00003

I need to insert code so it should read AcademyID "New Line" WeaponSerial

Any help would be greatly appreciated.

 

[shknbk2]

Application.SendKeys Chr(13), True

 

[cskelk]

This did not work

 

[Logit]

You don't want to use the ENTER key in SendKeys to perform a function. It will prevent you from using the ENTER key
for anything else.

Better choice is to use a Command Button that you can click.

 

[shknbk2]

It worked on the fillable PDF I tried it on. Maybe it depends on how the form is created. Does switching 13 with 10 change anything?

 

[Logit]

Google SENDKEYS and review the list of variable numbers that can be used for all the different keys.