How to extract the metadata from PDF via VBA?

[Rudy_Xu]

In my daily work, I have to documentation from thousands of PDFs, and maintain its revision, so I copy the created date from the PDF properties manually.

I had searched the forums, and got some pieces of code to get the Title, Subject, Author, etc, but no the creation date or modified date.

Could someone help me to give me some pieces of code how to extract the data from PDF properties? Or the function?

                

Thanks for your help in advance and have a good day.

[Bernd Alheit · Accepted solution]

Look at the info property of the document. Details are in the Acrobat JavaScript Reference.

[Rudy_Xu]

Hi Bernd

Thanks for your quick response.

But I'm a rookie, I just know little about VBA.

Are there any VBA solution?

[Test Screen Name]

Did you read the reference we suggested?

[Rudy_Xu]

No, because I have no knowledge about java.

[try67]

It's not Java, but JavaScript. And if you want to automate Acrobat then you should get familiar with it.

[Test Screen Name]

Note that you can use the VB:JavaScript connector to use JavaScript objects from VBA.