Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to check if a URL is working
To the masters of microsoft excel:
Is it possible using a VBA to check a couple of links (Range("A1:A100")) are working properly? I want to open the URL and check if that particular article has been expired or not? Is there a way to do it? Thanks & Regards -Dileep Chandran |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to check if a URL is working
Dileep,
Something like this, although there are probably other errors that that will cause the method to fail that you should include. Just try and get it and if it fails, then it's not the Private Sub CommandButton1_Click() On Error GoTo Handler ThisWorkbook.FollowHyperlink "http://yoursite.com/somefilethatdoesnotexist.txt" Exit Sub Handler: Select Case Err.Number Case -2146697210 MsgBox "File not available" Case Else End Select End Sub NickHK "Dileep Chandran" wrote in message ups.com... To the masters of microsoft excel: Is it possible using a VBA to check a couple of links (Range("A1:A100")) are working properly? I want to open the URL and check if that particular article has been expired or not? Is there a way to do it? Thanks & Regards -Dileep Chandran |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to check if a URL is working
Nick,
Its throwing out an error for me. -Dileep |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to check if a URL is working
Dileep,
It would help if you said which error. NickHK "Dileep Chandran" wrote in message ps.com... Nick, Its throwing out an error for me. -Dileep |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check box not working out for me.. why? | Excel Discussion (Misc queries) | |||
Check Box not working | Excel Discussion (Misc queries) | |||
Check Box Not working? | New Users to Excel | |||
Check boxes not working | Excel Programming | |||
Check variance code not working | Excel Programming |