| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
File Properties in Macros
SaveDateTime = FileDateTime(ThisWorkbook.Path & "\" & ThisWorkbook.Name
-- Message posted from http://www.ExcelForum.com |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
File Properties in Macros
Thanks!
-----Original Message----- SaveDateTime = FileDateTime(ThisWorkbook.Path & "\" & ThisWorkbook.Name) --- Message posted from http://www.ExcelForum.com/ . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
File Properties in Macros
Check out the BUILTINDOCUMENTPROPETIES....
http://tinyurl.com/39p9 -- Message posted from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| File properties | Excel Worksheet Functions | |||
| File Properties | Excel Discussion (Misc queries) | |||
| File Properties | Excel Discussion (Misc queries) | |||
| How do I get the file properties? | Excel Programming | |||
| Set properties in an XLS file.. | Excel Programming | |||
Linear Mode
