Clicking on Search Button to Scrape Data from Website on Intranet

[akash09]

Hello all, thanks in advance for any inputs, I am new to creating VBA macros. Creating a macro to scrape data from a website on the company's intranet to generate a report. I am able to login and reach the relevant search page, but on this page though I am able to input the selections but not able to write a command to click on search button.

Following image shows the highlighted Search button.

 

[Anthony47]

Try adapting this instruction to your programming context:

YourSession.document.getElementById("Bestsearchbutton").getElementsByTagName("Input")(0).Click

Bye

 

[akash09]

Thanks a lot!!! It worked.