• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Web link as image

sms2luv

Member
I have a webpage with a submit button.
I want to click the button but there is no button tag.
When I inspect the element its a IMG tag.
How can I make VBA code to click on IMG button to submit the page.
Its a intranet site so cannot provide the link
 
Search on the forum and read about Web Scraping.

Use developer tool on the browser to trace what requests are sent when the image is clicked. Use that information to write code using WinHttp or XMLHTTP library instead of navigating/controlling IE.
 
Here, read through links.
http://chandoo.org/forum/threads/wh...ils-in-website-through-vba.30640/#post-182628
http://chandoo.org/forum/threads/ex...doesnt-work-in-a-few-cases.28239/#post-169190

http://analystcave.com/web-scraping-tutorial/

Web scraping requires you to understand not only basics of VBA, but HTML DOM structure and/or string manipulation as well (it also helps to know bit of Java, JSON etc). But most importantly how to use the developer tool to understand what requests are sent to the server to get the information you are looking for.
 
Back
Top