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