Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting timestamp from a file in Excel
Hi,
I'm looking for a macro/function that will allow me to get the timestamps properties (date created) for a file in Excel and paste this into a particular cell. I imagined the set up would be something like: Cell A1 - File location Cell B1 - File name Cell C1 - =Today() Cell D1 - Some formula/macro/function that says "If the datestamp of A1&B1 is the same as C1 then put a tick" Can anyone help? Many Thanks Patrick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying File Timestamp of Another Excel File | Links and Linking in Excel | |||
Displaying File Timestamp of Another Excel File | Charts and Charting in Excel | |||
Excel Sheet Timestamp | Excel Worksheet Functions | |||
Getting timestamp from a file in Excel | Excel Worksheet Functions | |||
Timestamp function that does not update in Excel? | Excel Worksheet Functions |