ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Insert date modified of external file (https://www.excelbanter.com/excel-discussion-misc-queries/52229-insert-date-modified-external-file.html)

flaterp

Insert date modified of external file
 
I have a hyperlink to an external file in one cell and wish to output the
modified date of that file (not the cell, worksheet, or spreadsheet) to
another cell. The target file does not change directories. Is this
possible? Thanks in advance.

flaterp

Insert date modified of external file
 
Would 'filedatetime' be applicable in this situation? I'm not familiar with
the syntax, but I would like the pathname to be equal to the value to its
immediate left. For instance, cell A2 contains hyperlink to
\\domain-x\filler$\morefiller.txt and I would like the modified date of this
file to appear in B2. Hope this clarifies things. Thanks.


All times are GMT +1. The time now is 04:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com