Tabbing in a PDF form without XL crashing

[VBAIntermediate]

Hi all,

I am trying to populat a PDF form based on data in XL. I have opened the file and the document successfully and can enter data in the first cell fine, but after that my PC crashes :

        Application.SendKeys "{Tab}", True
        Application.SendKeys Name, True
        Application.SendKeys "{Tab}", True
                
        Application.SendKeys Age, True
        Application.SendKeys "{Tab}", True

Any ideas?

 

[VBAIntermediate]

Hi all,

I am trying to populat a PDF form based on data in XL. I have opened the file and the document successfully and can enter data in the first cell fine, but after that my PC crashes :

        Application.SendKeys "{Tab}", True
        Application.SendKeys Name, True
        Application.SendKeys "{Tab}", True
                
        Application.SendKeys Age, True
        Application.SendKeys "{Tab}", True

Any ideas?

I notice that while my PC is crashing, if I click into XL and hit escape, it populates the "Age" value in whatever cell I clicked into to hit escape - any advice?

 

[VBAIntermediate]

I notice that while my PC is crashing, if I click into XL and hit escape, it populates the "Age" value in whatever cell I clicked into to hit escape - any advice?

Or even if someone knew a way to write a macro to carry over data from XL into a fillable PDF?

Any pointers would be great.