Edge - Updating URL on existing Browser Tab

[markf5998]

I have some code that loops through a bunch of selected cells and for each one, searches for that term on a website...it works, but each search term results in a new browser tab. Any suggestions on how I can get just 1 tab to cycle through each term?

For Each Cell In Selection

    Application.Wait (Now + TimeValue("00:00:" & WaitTime))
    SearchTerm = Cell.Value
    CreateObject("Shell.Application").ShellExecute "https://www.myURL.com/s?searchTerm=" & SearchTerm

Next Cell

 

[Rijnsent]

Hi Mark,
you'd have to add quite a bit of code, basically automating Edge/Chrome. Currently, the "CreateObject" line causes the new tabs, so you'd need to first set a "browser object" and after that use that object to browse to your different pages. I assume you also want to process the result? If so, VBA can also do that...

Some examples/resources (found searching for "excel vba automate browser"):

Simple class for browser automation in VBA - Analyst Cave

A simple tool to provide deterministic browser automation in VBA. Simple browser automation VBA code

analystcave.com

Automate Chrome / Edge using VBA (a bit more advanced)
Docs | VBA-Web (a full library with tools)

Cheers,

Koen

 

[markf5998]

Hi Mark,
you'd have to add quite a bit of code, basically automating Edge/Chrome. Currently, the "CreateObject" line causes the new tabs, so you'd need to first set a "browser object" and after that use that object to browse to your different pages. I assume you also want to process the result? If so, VBA can also do that...

Some examples/resources (found searching for "excel vba automate browser"):

Simple class for browser automation in VBA - Analyst Cave

A simple tool to provide deterministic browser automation in VBA. Simple browser automation VBA code

analystcave.com

Automate Chrome / Edge using VBA (a bit more advanced)
Docs | VBA-Web (a full library with tools)

Cheers,

Koen

Great info, thank you!