Well I'm new but I know what I want to do I just dont know how or what to use. Ok so here's what I've been doing. I've been copying and pasting links into Excel, because it copies the whole hyperlink too.

So Like one I have is 29 Highlands Blvd it's hyperlink is http://www.zillow.com/HomeDetails.htm?zprop=18233287 and I have thousands of these however when I go into that link it takes forever to load, time I could be using doing other things. Once I'm in I click on the link for "Contact" and it takes me to http://www.zillow.com/contact/Contac...zprop=18233287 what I would like to do is bypas the HomeDetails.htm link and go straight into the ContactForm.htm but it would take me days to go through each link I have and modify it, and again that is time I could use doing something else. So my question is. Is there a way to automatically change the links I have so that everything before ?zprop=18233287 changes to http://www.zillow.com/contact/ContactForm.htm ???

Any help would be much appreciated

Nevermind I had a case of Cognitive Rigidy but its ok now :)

You will need to look into VBA to handle this.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========