Guest User

Untitled

a guest
Jan 18th, 2018
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. $excel = New-Object -ComObject Excel.Application
  2. $excel.Visible = $false
  3. $workbook = $excel.Workbooks.Open("C:testexcel.xls")
  4. $binding = "System.Reflection.BindingFlags" -as [type]
  5. Foreach($property in $workbook.BuiltInDocumentProperties)
  6. {
  7. $pn = [System.__ComObject].invokemember("name",$binding::GetProperty,$null,$property,$null)
  8. trap [system.exception]
  9. {
  10. write-host -foreground blue "Value not found for $pn"
  11. continue
  12. }
  13. "$pn`: " +
  14. [System.__ComObject].invokemember("value",$binding::GetProperty,$null,$property,$null)
  15. }
  16. $excel.quit() </code> <br> Can someone please assist:
  17.  
  18. [System.__ComObject].invokemember("name",$binding::GetProperty,$null,$property,$null)
  19.  
  20. $lst=$workbook.BuiltinDocumentProperties("Last Save Time")
  21. [System.__ComObject]$lst.invokemember("value",$binding::GetProperty,$null,$property,$null)
Add Comment
Please, Sign In to add comment