Greetings. I'm re-visiting the latter half of one of my automation projects. I've found a command line tool from PDF Labs that appears to have the functionality I'm looking for without needing to have a lot of VBA do the heavy lifting.

I can get the metadata on pdf files output as .txt. The last line (and it's always the last line) in the file is "NumberOfPages: 20". And, at the moment, the quantity of pages is the only data I'm concerned with. Is it easier to "pluck" this number/value from this text file? Or should I write the VBA to count the number files (pages), which I'll need to pass back to this tool from PDF Labs?

TIA,

AvgJoe

Test it as many times. If its yielding 100% correct, then there's no need to think of a better vba alternative.