Web scraping

[PhillipC]

Hi - I am trying to understand how to interact with the web from VBA Macro. The code below will sometimes simulate inputting "atn x-sight 5" into Google Search and clicking the Google Search button. However, most of the time it does not work. If I step through the code and place the cursor after "atn x-sight 5" in the search box before executing the line "Element.click", it works every time. Please help.

Please Login or Register  to view this content.

[alansidman]

Administrative Note:

We would very much like to help you with your query, however your post does not comply with our guidelines

Please take a moment to review how to add code tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Guideline #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here.

I have added the code tags for you today. Please take a few minutes to re-read our guidelines and rules that you agreed to when you joined and comply in the future.

[PhillipC]

Thank you for your guidance. I will be sure to add code tags in the future. Thanks again.

[ByteMarks]

You might want to explore Selenium webdriver

It allows you to automate modern browsers such as Chrome.
You need to download and install the Selenium library and make sure you have a Chrome Driver associated with your version of Chrome.
https://www.simplilearn.com/tutorial...er-in-selenium

https://developer.chrome.com/docs/ch...iver/downloads