Thank you very much for considering Aspose.
Aspose.Pdf.Kit allows you to fill the PDF form template and then flatten the fields. You can see the following topics for more details:
In addition to that, you can use Aspose.Cells to export data from an Excel sheet and import that data into PDF form using Aspose.Pdf.Kit after that you can use FlattenAllFields method of Aspose.Pdf.Kit to flatten the filled fields in the PDF.
A complete example of the above scenario can be found in the following topic:
[Export Excel Worksheet Data to Fill PDF Form]
As far as your requirement to use Aspose.Pdf.Kit for .NET with VBA is concerned, we have not yet tested this requirement. I have logged it as PDFKITNET-11248 in our issue tracking system. We’ll test this requirement at our end and update you accordingly via this forum.
If you’re interested to test the Aspose.Pdf.Kit for .NET you can download it from the download section.
If you have any further questions, please do let us know.