I have seen numerous posts on how to get Excel to automatically test hundreds of links in a worksheet. however, i have never been able to get it to work for my case.
I have a worksheet and would like to test each of the links automatically. If they are valid, do nothing, if they are invalid either color them yellow or put a comment in Column Z that says Invalid, or similar.
I am using Excel 2007. Thank you, in advance, for your help.
Last edited by friedboudinball; 11-11-2011 at 09:37 AM.
any thoughts?
Yes, many based on your sample workbook.
Basically:
Please Login or Register to view this content.
Last edited by snb; 11-11-2011 at 09:58 AM.
that works well ... thanks ...
is there a way it can test but not open the windows? If i have thousands to test, i'm afraid that would overload my PC.
if that is not an option, can I test a range?
after loading a reference to microsoft XML, version 2.0 (or another that contains XMLHTTPRequest)
Please Login or Register to view this content.
anyway to limit it to a certain range of cells?
No need to.
Did you run the last code ?
not yet ... i need to figure out how to get the XML
VBEditor (Alt-F11), menubar / extra/references/ click Microsoft XML, etc.
Went to Tools, References, added the Microsoft XML 6.0 and still gives me this message:Originally Posted by snb
Compile Error: User-Defined type not defined, while highlighting the "New XMLHTTPRequest"
You are the only one able to check the availability of Microsoft XML-libraries on your system.
So how do i check? I have added the XML add-in. Is there somewhere else i should be looking?
Load the Microsoft XML 2.0 version.
Nice simple programs, thanks.
The first one reports an error value of '0', so it works great - except for leaving all the files open.
The second one, requiring XML, is returning an error code value of '-2147467259' for the same files!?
I have tried adding a 10 second delay after the '.send' line in case the error is caused by a process timeout, as the files on on our network. The delay works but the error still exists. The 'Err.Clear' is changing the value to '0' as expected, so the error must be generated by the code.
Does anyone know where I can find out what the error value relates to and better still, how to eradicate it.
Learner22,
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Please refer to new thread with the same title, thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks