Hey
Is there anyway to count number of pdf pages in "home" folder in desktop? ( the home folder has multi folders and multi pdf files in the folders )
and just show the result in A1
Thanks
Hey
Is there anyway to count number of pdf pages in "home" folder in desktop? ( the home folder has multi folders and multi pdf files in the folders )
and just show the result in A1
Thanks
This code may help, but its show all paths and every file has x pages, i just want to print total pages in all files
Please Login or Register to view this content.
Try changing this:
To this:Please Login or Register to view this content.
And place lPDF_PageCount where you want the value displayed.Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Sorry but I didnt get it, I want to print only the number
kindly can I have ready excel file?
Share the workbook where you tried to implement the suggestion.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I have this excel
its didn't see the pdf files in subs folders, only see in main folder, I want to fix this
also no need to print table with file name and number of pages
I just want to save this values in variable
npages = total numbers of pages ( in all files )
nfiles = total number of pdf files ( in all folders in path )
size = size of the main folder I selected in path ( mean how many MB - GB? )
Thanks
Last edited by Undo; 01-16-2021 at 04:22 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks