LinkBack URL
About LinkBacks
Is it possible to import a pdf's data into Excel using VBA? And if so, how would I go about doing this?
Thanks
Is it possible to import a pdf's data into Excel using VBA? And if so, how would I go about doing this?
Thanks
And keeping the same format as the PDF? It may be possible via some advanced VBA, but I gave up on this some time ago. If you want to copy only the data, that can be done via clipboard. It is also possible using the Pro version from Adobe, not Adobe Reader.
Click the * to say thanks.
I'm looking for that advanced VBA option, if it's out there.
It would I think depend on whether the pdf content is an image or actual text, and whether you have a PDF application that supports automation, like Distiller.
Rory
I expect you'd do this by exporting the PDF to Excel using Acrobat. My version (Acrobat DC Standard) supports doing this from the user interface, but not (that I can find) via VBA. I suspect that the Professional version supports it, but don't know for a fact. Suggest you ask on an Acrobat forum.
Entia non sunt multiplicanda sine necessitate
Hello,
If I have a pdf form with defined fields, can I add one form to an existing excel file?
I am interested in filling out the form and sending some of the fields to an existing excel file.
Can this be done?
Thank you
Look at this link
https://exceleratorbi.com.au/import-...g-power-query/
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks