Excel VBA - Last Author properties

[panthi]

HI !
I want to read Last Edited properties from Excel files withou
opening.
For example: in Workbook a.xls I have a macro and I would like rea
Last Edited properties from b.xls.

Help me, please.

P.S.
Sorry my english ;-

 

[Frank Kabel]

Hi
not sure if this is event possible without opening the
other file. I would open the file in the background (set
screenupdating to false) and get the properties with the
following function:

Function DocProps(prop As String)
application.volatile
On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties
(prop)
Exit Function
err_value:
DocProps = CVErr(xlErrValue)
End Function


In your case with
author=DocProps("Author")

 

[Melanie Breden]

HI !

I want to read Last Edited properties from Excel files without
opening.
For example: in Workbook a.xls I have a macro and I would like read
Last Edited properties from b.xls.

Try this:
CreateObject("Scripting.FileSystemObject").GetFile("C:\b.xls").DateLastModified

--
Regards

Melanie Breden
- Microsoft MVP für Excel -

http://excel.codebooks.de (Das Excel-VBA Codebook)

 

[TroyW]

Microsoft KB Article 224351 may be of interest.

Dsofile.exe Lets You Edit Office Document Properties from Visual Basic and
ASP
http://support.microsoft.com/support/kb/articles/Q224/3/51.ASP

Dsofile.exe is a self-extracting executable that provides a simple
in-process ActiveX component for programmers to use in order to read and
modify the Document Summary Properties for an OLE Structured Storage file
such as native Excel, PowerPoint, Microsoft Visio, and Word documents
without using Automation to Microsoft Office.

Troy