PDA

View Full Version : Accessing WebDAV file properties



jamiechipper
10-28-2008, 05:40 AM
I am in the need to find file properties (i.e. modified date) of a web folder (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

jamiechipper
10-28-2008, 12:17 PM
Here is the solution (early bound):

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"))