check if hyperlink still works

[Frank M]

Hello,

i'm using a cross matrix which contains hyperlinks to other documents. I
build an interface with VBA. Whe you enter an input and output on the vba
form it will pick up the value of the cell. After you click on it (in the vba
form) it will open the document where the hyperlink refers to.

Now for my problem. I have a function which checks if the cell has a
hyperlink. What i don't get to work is a check if the hyperlinkaddress is
still correct. Because when i try to open the document (and the hyperlink
isn't correct anymore) my program goes to VBA because of an error.

Is there a way to check if the hyperlink is still valid?

Grt,

Frank

 

[Jakobshavn Isbrae]

Perhaps:

http://groups.google.com/group/micr...af89096d77b6?hl=en&lnk=st&q=#0187af89096d77b6

 

[Frank M]

Yes, it did the trick.
I only need to change it a bit to my code, but i will get it to work

Thanks

 

[Jakobshavn Isbrae]

I am glad to help. This is my first answer to another's post.