| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check if file on intranet exists
That's it works perfectly! Thanks a lot.
"Tim Williams" wrote: Use xmlhttp and a "HEAD" request: '*********************** Function HttpExists(sURL As String) As Boolean Dim oXHTTP As Object Set oXHTTP = CreateObject("MSXML2.XMLHTTP") oXHTTP.Open "HEAD", sURL, False oXHTTP.send HttpExists = (oXHTTP.Status = 200) End Function '*********************** Tim "mcphc" wrote in message ... I need to check if a file with path "http://pmnet/113-FR-001.xls" exists without opening it. I've tried using Dir(myPath) but I get an error 52 'Bad file name or number'. I've also tried using the FileExists method in VB but I'm not sure how to use it. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check if a File Exists | Excel Programming | |||
| Check if file exists | Excel Discussion (Misc queries) | |||
| How to check if a file exists in an ftp folder | Excel Discussion (Misc queries) | |||
| check if file exists | Excel Programming | |||
| check if a file exists / is open | Excel Programming | |||
Threaded Mode
