ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Date Modified from an External Internet Source (https://www.excelbanter.com/excel-programming/327808-date-modified-external-internet-source.html)

UBER_GEEK

Date Modified from an External Internet Source
 
Im trying to gather information on when a .csv is updated everyday.
Its supposed to be updated everyday at the same time, but its not. So i
have to open and compare to other .csv's ive archived.

the problem is the csv is on my local intranet
Anyone have a good clue on how to get when the file was updated?

Thanks


Tom Ogilvy

Date Modified from an External Internet Source
 
try filedatetime command
? filedatetime("H:\xlText\xl_commandbar_articles.txt ")
09/01/2004 11:28:40 AM

?
filedatetime("\\MyServer\home\O\ogilvytw\xltext\xl _commandbar_articles.txt")
09/01/2004 11:28:40 AM


--
Regards,
Tom Ogilvy



"UBER_GEEK" wrote in message
oups.com...
Im trying to gather information on when a .csv is updated everyday.
Its supposed to be updated everyday at the same time, but its not. So i
have to open and compare to other .csv's ive archived.

the problem is the csv is on my local intranet
Anyone have a good clue on how to get when the file was updated?

Thanks




UBER_GEEK

Date Modified from an External Internet Source
 
I Read up on that function prior to posting, it dosnt seem to work when
i use an http url, i do not have access to the drive this is kept on,
but can access the webpage and download the csv.



All times are GMT +1. The time now is 10:28 AM.

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