Hi. I am trying to pull the URL of a certain image when using the ie.getelementby... method.
Using the following I can access the url I need but it's surrounded by html code that is proving difficult for me to seperate out:
test = ie.document.getElementById("recaptcha_image").InnerHtml
this is what debug.print test shows me:
<IMG style="DISPLAY: block" alt="reCAPTCHA challenge image" src="http://www.google.com/recaptcha/api/image?c=03AHJ_VuseNxC9vqebkGvR3AamjyyeAaPVUSkJcCkZ6fVvhQbxIOC8YiIZHV9p6-Ay-09daLWUf3BSIeYIHqczZVIKAhdFR_HnqTlEMUXNga81zlDAIJ2fwwM9qMEgLxkXM568OSGCvuiQn-QVI6Ob7y1RWKXpMEjIMA" width=300 height=57>
does anyone have any suggestions or a completely different way I should be looking at the image source?
Just for clarity, I'm pulling an image from a site and pasting it into a specified cell. I already have part 2 working but I have to pass in the necessary url. If I paste in the url from getelementbyid (manually extracting it) the correct image shows up in excel.
I don't believe im violating any terms of service regarding captcha as im still requiring a person to type in the response.
thanks in advance!
Using the following I can access the url I need but it's surrounded by html code that is proving difficult for me to seperate out:
test = ie.document.getElementById("recaptcha_image").InnerHtml
this is what debug.print test shows me:
<IMG style="DISPLAY: block" alt="reCAPTCHA challenge image" src="http://www.google.com/recaptcha/api/image?c=03AHJ_VuseNxC9vqebkGvR3AamjyyeAaPVUSkJcCkZ6fVvhQbxIOC8YiIZHV9p6-Ay-09daLWUf3BSIeYIHqczZVIKAhdFR_HnqTlEMUXNga81zlDAIJ2fwwM9qMEgLxkXM568OSGCvuiQn-QVI6Ob7y1RWKXpMEjIMA" width=300 height=57>
does anyone have any suggestions or a completely different way I should be looking at the image source?
Just for clarity, I'm pulling an image from a site and pasting it into a specified cell. I already have part 2 working but I have to pass in the necessary url. If I paste in the url from getelementbyid (manually extracting it) the correct image shows up in excel.
I don't believe im violating any terms of service regarding captcha as im still requiring a person to type in the response.
thanks in advance!
Last edited: