Free Support Forum -

Does it work with vba

Good day,

We have a small Excel/VBA application that needs to fill PDF form.

Basically, it is a data entry form, and we need to capture a contract details like customer name, address, phone number etc. and fill these details into a PDF template form, then save it as a flatten pdf file.

I wonder Aspose has any components that allow us to achieve this?

This message was posted using Aspose.Live 2 Forum

Hi Viet,

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:

How to Fill Form Fields With API?
Import and Export into XML

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.

The issues you have found earlier (filed as ) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan