Reputation: 1
I have written a macro to fill in a Foxit pdf from Excel. The macro populates all info on the first customer row via SendKeys and then loops to the second customer, etc. The code executes without issue. My problem is that when I try to reset the form using shortcut keys that I have assigned, nothing happens. Here is the command:
Application.SendKeys "^+(r)", True 'Reset Form
Application.Wait Now + 0.00006
I need to reset the form as some of the options are checkboxes and some of the fields may be blank. I created a longer wait time to attempt to ensure the command executes. No luck. Similar code for saving the pdf works fine:
Application.SendKeys "^+(s)", True 'Save As
Application.SendKeys "C:\Users\......" & LastName & "\" & FirstName & "_" & "Arrangement" & ".pdf"
Application.Wait Now + 0.00003
Thank you for any help.
Upvotes: 0
Views: 580