DEAR ALL
但是我不知道擁有者的語法, 測試 .Dateowner或 .DateUserName都錯誤
目前我只知道檔案建立日期語法如下:
Dim FSO As Object, Xa As String, Ax As Integer
Set FSO = CreateObject("Scripting.FileSystemObject")
Xa = Sheet1.[D1048576].End(xlUp).Row
For Ax = 8 To Xa
If Sheet1.Cells(Ax, 3) <> "" Then
Sheet1.Cells(Ax, 6) = FSO.GetFile(Sheet1.Cells(Ax, 4)).DateCreated
' Set FSO = Nothing
End If
Next
Title
Subject
Author
Keywords
Comments
Template
Last author
Revision number
Application name
Last print date
Creation date
Last save time
Total editing time
Number of pages
Number of words
Number of characters
Security
Category
Format
Manager
Company
Number of bytes
Number of lines
Number of paragraphs
Number of slides
Number of notes
Number of hidden Slides
Number of multimedia clips
Hyperlink base
Number of characters (with spaces)作者: rouber590324 時間: 2018-9-19 14:48