Accessing the "Date Last Saved" using PowerShell

Question

I am attempting to access the Date Last Saved of an xls file using PowerShell. It is in the details page and is more of a hidden attribute of the file. Pic attached for reference.

Date Last Saved

EDIT: Thank you for the help. Both solutions work but I am in a constricted language mode so I can't use them :(

Otter · Accepted Answer · 2021-07-21 15:54:54Z

2

Went down a bit of a rabbit hole for this one but I found the below.

The attribute is not part of the file properties. It is part of the worksheets properties (as are many attributes).

Full credit goes to Ed Wilson and Craig Liebendorfer, Scripting Guys - https://devblogs.microsoft.com/scripting/hey-scripting-guy-how-can-i-read-microsoft-excel-metadata/

$excel = New-Object -ComObject Excel.Application
$excel.Visible = $false
$workbook = $excel.Workbooks.Open("C:\temp\Test.xlsx")
$binding = "System.Reflection.BindingFlags" -as [type]

Foreach($property in $workbook.BuiltInDocumentProperties){
    if ([System.__ComObject].invokemember("name",$binding::GetProperty,$null,$property,$null) -eq "Last save time"){
        [System.__ComObject].invokemember("value",$binding::GetProperty,$null,$property,$null)
    }
}
$excel.quit()

edited Jul 21, 2021 at 15:54

answered Jul 21, 2021 at 15:47

Otter

1,1729 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

FoxDeploy · Accepted Answer · 2021-07-21 15:54:20Z

0

Previously I had an answer discussing how to retrieve basic file info, but to access Office file info, you have to do a bit more work...

Using this answer from a previous question, I made a PowerShell function to make this easy for you.

Source Here on github

Usage

Get-OfficeFileInfo  C:\temp\UsersOfabc.comDomain.xlsx 

Name             Exp                  
----             ---                  
Title                                 
Subject                               
Author                                
Keywords                              
Comments                              
Template                              
Last author      Stephen Owen         
Revision number                       
Application name Microsoft Excel      
Creation date    7/21/2021 11:30:51 AM
Last save time   7/21/2021 11:30:51 AM
Security         0                    
Category                              
Format                                
Manager                               
Company                               
Hyperlink base                        
Content type                          
Content status                        
Language                              
Document version

Getting the specific property you want

$fileInfo = Get-OfficeFileInfo  C:\temp\UsersOfabc.comDomain.xlsx 
$dateSaved = $fileInfo | ? Name -eq "Last save time"

C:\temp\> $dateSaved.Exp

Wednesday, July 21, 2021 11:30:51 AM

edited Jul 21, 2021 at 15:54

answered Jul 21, 2021 at 15:29

FoxDeploy

13.8k3 gold badges42 silver badges58 bronze badges

2 Comments

Charles Davis Over a year ago

The .DateModified is not what I am looking for. I am downloading a .xls file and when I download it the .DateModified is the download time. I am looking for the date that the file was last saved. I can see that property in the properties of the file but can't access it through PowerShell.

FoxDeploy Over a year ago

I redid my answer, i misinterpreted the question before.

Collectives™ on Stack Overflow

Accessing the "Date Last Saved" using PowerShell

2 Answers 2

Comments

Usage

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Usage

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related