×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Verifying Hyperlinks in Excel

Verifying Hyperlinks in Excel

Verifying Hyperlinks in Excel

(OP)
I have a sheet in Excel that has 3000 drawings listed on it.  When you click on the drawing name, a tif image of that file will come up by using simple hyperlinks.  The problem is that we shipped the main Excel file and all of the drawing files to our customer and he says that some of the files cannot be located but he cannot tell us which ones. Is there a way in Excel 2000 to verify all of the hyperlinks without clicking on each one?
I'd appreciate any help I can get.
Thanks,
Lori

RE: Verifying Hyperlinks in Excel

Seems like this could be done using the fileexists method from VBA.

RE: Verifying Hyperlinks in Excel

(OP)
Sorry, I am not familiar with VBA.  I was hoping to find some kind of command already in Excel to verify the links.  It seems like something that should be in there.
Thanks anyway,
Lori

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources