Accessing WebDAV file properties
I am in the need to find file properties (i.e. modified date) of a web file (WebDAV) through VBA. The FileDataTime function does not work for web files. Does anyone know of a library that is on a standard Windows XP build that can access these properties? Any example code?
Thanks,
Jamie
Re: Accessing WebDAV file properties
Here is the solution:
Dim objXML As MSXML2.XMLHTTP
Set objXML = New MSXML2.XMLHTTP
Call objXML.Open("GET", "THEFILE", False)
objXML.send
Do Until objXML.readyState = 4
Loop
Call objXML.getAllResponseHeaders
Call msgbox (objXML.getResponseHeader("Last-Modified"))