ExcelBanter - File Properties in Macros

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - File Properties in Macros (https://www.excelbanter.com/excel-programming/298606-file-properties-macros.html)

jeff

File Properties in Macros

Is it possible to retrieve the file properties for the
file of the current worksheet in a XL 2000 macro? I can
view them interactively (File|Properties|Statistics) but
don't know how to obtain it in a macro. Am particularly
interested in the last-saved datestamp.

Thx.

mudraker[_219_]

File Properties in Macros

SaveDateTime = FileDateTime(ThisWorkbook.Path & "\" & ThisWorkbook.Name

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

jeff

File Properties in Macros

Thanks!
-----Original Message-----
SaveDateTime = FileDateTime(ThisWorkbook.Path & "\" &
ThisWorkbook.Name)

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

.

dmang

File Properties in Macros

Check out the BUILTINDOCUMENTPROPETIES....

http://tinyurl.com/39p9

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

All times are GMT +1. The time now is 02:24 AM.