•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to count the number of pages of each PDF on a list?
Hello,
I'm frequently using power query for listing all the files in a folder.
Now when I list PDF files, it looks something like this:
File01.pdf
File02.pdf
File03.pdf
etc...
What I need to produce is something like
File01.pdf
| Name | Number of pages |
|---|---|
| File01.pdf | 32 |
| File02.pdf | 201 |
| File03.pdf | 12 |
etc...
Basically, I need to read the number of pages from each PDF file fully automatically and have it update as I add and remove files from the folder. I don't need to read any other data from the PDF's.
Is there a way to do this without VBA? I need to be able to share my workbooks with third parties who might fully justifiably disable any VBA in the workbook.
Thank you for your answers in advance.
[link] [comments]
Want to read more?
Check out the full article on the original site