Okay all, this is a common problem that I've run into before... However, with updated software, the methodologies change a bit. Here is my latest method of collecting table data from a PDF without purchasing adobe or another 3rd party software solution.
**NOTE: These methods were discovered online by searching. I did not come up with them. I'm just sharing, because that's how we get smarter together!
How to collect the data using PowerQuery:
http://simblais.com/simblogue/blog/2013/12/16/using-power-query-on-a-pdf-with-some-help-from-word/
**I use the "Load To..." option to drop the tables directly into a worksheet instead of the data model.
How to Consolidate the many worksheets into one sheet (I used the VBA code in the article):
http://excel.tips.net/T003005_Condensing_Multiple_Worksheets_Into_One.html
**I added the following line at the bottom of the code to show the final worksheet: Sheets("Combined").activate
Again, these solutions are not my work, but definitely useful. Please give these sites their due respect if you find this information useful.
No comments:
Post a Comment