I created an Excel VBA script to create a table that is in the same format as a fillable tax spreadsheet. I would like to copy the cells from Excel to the fillable tax spreadsheet, but when I try to manually paste the Excel table into the Adobe PDF, it pastes into one cell instead of all the cells. How can I fix this?
I have attached the fillable pdf and my Excel data. I would like to paste the Excel table into the large table on the second page of the pdf.
Eventually, I would like to script this in VBA, but I want to know how to do it manually first.
Copy link to clipboard
Possible as in "perhaps the pasted data could be programmatically parsed, split and assigned to appropriate fields". But I don't think so.
Certainly nothing you can do manually; you can put form fields in a grid in Acrobat, but there is no row or column relationship. They might look the same, but they need a completely different worldview.
Does Acrobat have any way to reference a specific cell, like can I rename the cell fields in Acrobat somehow and then use those field names in VB?
There are no "cells" in Acrobat, only fields. You can refer to them in your code using their name.
And there is no way to directly rename them using a script, no.
If the file has security set, everthing may be impossible, however. Check this before wasting more time.
I almost have it solved. I used VB to create several XML files from my database, which I tested importing in Adobe Acrobat Reader using Edit -> Form Options -> Import Data. The XML files successfully populate the form.