I'm using VBA to populate a fillable PDF with several different cells per row. I'm running this as a loop of 3 to 4 rows and I'm looking to clear the PDF form before importing the next row of data.
The flow of the code is: open the template, fill the form, save the form, create a hyperlink within the Excel file, and *hopefully* clear the form before moving on to the next row to repeat the process.
Does VBA have a reset/clear form command? How would this code be structured?
Any help would be immensely appreciated!
