Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations KootK on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

check the link_broken

Status
Not open for further replies.

llbbyy

Mechanical
Mar 21, 2017
21
Hello, everyone.
I write a reorder macro,it works perfect when parts links well, but if there is any link broken, error occurs. How to check the link broken by marco automatically, and if link-broken exsits, the macro will skip or give a warn.
Thank in advance.
 
Replies continue below

Recommended for you

Hello,
you want to reorder parts or? If you want that, search the forum there is a great macro for that.

[link catiavbmacro.com]catiavbmacro.com[/url]
 
I download source code Sorter from the forum. it works well, but if link-broken exsits, it'll have no reaction. So I hope to modify it with link-broken dection, when there is link-broken, it'll skip it or give a warn. but I don't known how to do.
 
 https://files.engineering.com/getfile.aspx?folder=5e814b9a-7c9b-4067-9aec-dc5654744533&file=Sorter.zip
error handling?

on error resume next
if err.number <>0 then
...​
else
...​
end if
on error goto 0

regards,
LWolf
 
If I want to list all link-broken parts by macro, how will I do?
 
catiavbmacro, Thank you very much.What a pity, I cannot enter that web. can you paste a attachment for that code.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor