CODEWITHSUNDEEP
excelvba
Vishal Mishr
Vishal Mishr

Reputation: 207

Extract the Pdf creation/modification date automatically

I have lots of Pdf file weblink saved in my excel file from which I have to extract the date of pdf creation. Checking One by one will take too much time. Is there any way to extract the creation date of all the files automatically in excel.

Upvotes: 1

Views: 845

Answers (1)

Kürsat Aydinli
Kürsat Aydinli

Reputation: 121

If I understand you correctly, then the recorded PDF files are stored locally on your computer. If this is the case and you know the path of any single PDF file, you can use the DateLastModified property of a file and print the modification date as follows:

Dim fs, f, s
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFile(filespec)
Debug.Print "Last Modification Date: " & f.DateLastModified

Whereas filespec represents the PDF file path

Futhermore check out following link: https://www.excelbanter.com/excel-discussion-misc-queries/125766-how-use-datelastmodified-property-vba.html

Upvotes: 1

Related Questions