Excel VBA - Last Author properties
 

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 ;-

--
Message posted from http://www.ExcelForum.com

Excel VBA - Last Author properties
 

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")
-----Original Message-----
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.

Help me, please.

P.S.
Sorry my english ;-)


---
Message posted from http://www.ExcelForum.com/

.

Excel VBA - Last Author properties
 

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)

Excel VBA - Last Author properties
 

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.../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


"panthi " wrote in message
...
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.

Help me, please.

P.S.
Sorry my english ;-)


---
Message posted from http://www.ExcelForum.com/