Home

Clearing Fields in PDF Form

%3CLINGO-SUB%20id%3D%22lingo-sub-825027%22%20slang%3D%22en-US%22%3EClearing%20Fields%20in%20PDF%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-825027%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20using%20VBA%20to%20populate%20a%20fillable%20PDF%20with%20several%20different%20cells%20per%20row.%20I'm%20running%20this%20as%20a%20loop%20of%203%20to%204%20rows%20and%20I'm%20looking%20to%20clear%20the%20PDF%20form%20before%20importing%20the%20next%20row%20of%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20flow%20of%20the%20code%20is%3A%20open%20the%20template%2C%20fill%20the%20form%2C%20save%20the%20form%2C%20create%20a%20hyperlink%20within%20the%20Excel%20file%2C%20and%20*hopefully*%20clear%20the%20form%20before%20moving%20on%20to%20the%20next%20row%20to%20repeat%20the%20process.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20VBA%20have%20a%20reset%2Fclear%20form%20command%3F%20How%20would%20this%20code%20be%20structured%3F%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20immensely%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-825027%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Concileus
New Contributor

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!

Related Conversations
Display PDF in Tab
JTHOUMEL in Microsoft Teams on
7 Replies
AIP and PDF
Rodolfo Umana in Azure Information Protection on
9 Replies
Flow always running as Owner
pnparadis in PowerApps & Flow on
2 Replies