check if hyperlink still works

F

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
 
F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top