Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
External data source | Excel Discussion (Misc queries) | |||
DATE FORMAT IN PIVOT TABLE FROM EXTERNAL DATA SOURCE | Excel Discussion (Misc queries) | |||
Insert date modified of external file | Excel Discussion (Misc queries) | |||
External Data Source | Excel Programming | |||
How do I pull multiple queries of external data from the Internet into Excel? | Excel Programming |