Hello!
I am working with pdf files containing text and tables. Unfortunately, when using Power Query, I get huge tables with a lot of 'null' values. And some lines and columns are shifted when I switch to a similar report for a different date.
However, if I first convert the pdf file to the Excel format, then I get a file that can be pulled up perfectly through PQ. I get a small and nice table.
Is it possible to use the advanced PQ editor and the web link to the pdf file to access the data of this file but only after some auto converting it to the .xls format? By default, when you try to open .pdf as .xls via PQ, it gives an error.
Excel finds table very good, main problem is text...it splits and shifts out when i change file (for similar report for another period/date)
so i want to get data as on the left (watch .xls) with only using vba or PQ and .pdf file web-link. its possible?
English is not my native language. Thank you for understanding and help.
Bookmarks