(Solved) – My VBA code to open Chrome and use the text from a cell is opening multiple tabs instead of just 1

  • by
(solved)-–-my-vba-code-to-open-chrome-and-use-the-text-from-a-cell-is-opening-multiple-tabs-instead-of-just-1

I have some text in cell B3 which I want to use to search Chrome. Sometimes the text has several words and for each word it is opening a separate tab. How do I work the code below to use the full text in a single tab?

Dim search As String

search = Range(“b3”).Value

Shell (“C:Program Files (x86)GoogleChromeApplicationchrome.exe -url ” & search)

Leave a Reply

Your email address will not be published. Required fields are marked *