If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

VBA Help!!!

grimsbymatt · 2006-11-10 11:52:28

Hi, I'm trying to write a VBA macro that edits all the hyperlinks in a word document. I think the problem I'm having is caused by it attempting to edit the hyperlinks contained in the contents index present in the documents. Does anyone know how to make it skip these links? Cheers.

Options

10-11-2006 12:52pm

#1

grimsbymatt

Closed Accounts Posts: 305 ✭✭

Join Date: February 2005

Posts: 281

Hi,

I'm trying to write a VBA macro that edits all the hyperlinks in a word document. I think the problem I'm having is caused by it attempting to edit the hyperlinks contained in the contents index present in the documents. Does anyone know how to make it skip these links?

Cheers.

0

Comments

Options
#2 13-11-2006 9:13pm
Ginger

Registered Users Posts: 2,931 ✭✭✭

Join Date: January 2003

Posts: 2658

Straight up..

Use On Error Resume Next

Then check for error and if there is one caused by invalid hyperlinks err.clear .. should work then.. not the most effecient but its a hack

0