Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assessing File's Properties
Does anyone know how to access the file's properties in the General Tab?
What I want to do is check when this file was created but the date in the General Tab- Created is different than in the Statistics Tab -created. Why is that???? And how do you do a check to see whether the date is before Nov 11 ...then do nothing...if it's after Nov 11 do something Thanks wEndy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assessing File's Properties
Wendy,
You have to use VBA to access the BuiltInDocumentProperties object. See www.cpearson.com/excel/docprop.htm for details. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Wendy" wrote in message .. . Does anyone know how to access the file's properties in the General Tab? What I want to do is check when this file was created but the date in the General Tab- Created is different than in the Statistics Tab -created. Why is that???? And how do you do a check to see whether the date is before Nov 11 ...then do nothing...if it's after Nov 11 do something Thanks wEndy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I change a file's properties in Excel? | Excel Discussion (Misc queries) | |||
Need help assessing problem. | Excel Discussion (Misc queries) | |||
Assessing unconventional projects | Excel Worksheet Functions | |||
Prompted to convert the file's text encoding... | Excel Discussion (Misc queries) | |||
How to get file's current directory path to a string in VBA? | Excel Programming |