#26 How to Automate Google Searches with VBA in Excel Using IE and Chrome

แชร์
ฝัง
  • เผยแพร่เมื่อ 15 ธ.ค. 2024

ความคิดเห็น • 3

  • @HypocrisyLaidBare
    @HypocrisyLaidBare หลายเดือนก่อน +1

    no mention of how to get the search query of multiple words in one window in chrome though, every multi words search returns a separate chrome window for each word in the input box
    example: search for "domesticated animals" in the input box (query) and chrome returns two open tabs one for "domesticated" and a second for "animals", and not one chrome tab for "domesticated animals" which is a totally different series of websites and information to the two strings when searched separately. "domesticated animals" is a term, and "domesticated" & "animals" are both words when used singularly. as a result they mean different thing when linked together than the sum of their individual meanings when separate.
    My point is that the VBA code is returning a faulty result for a searched "term" (string of words), and returns the singular of each word.
    Another example would be "weather maps UK" the desired result would be a chrome result showing a map that covers the UK and is related to weather.
    However, the VBA code above would return separate chrome tabs for each of the definitions of what the words "map", "UK", and "weather" mean. (Completely useless information)
    All of which are unconnected to what is required of the search query

    • @Mindful_Explorer
      @Mindful_Explorer  28 วันที่ผ่านมา +1

      Oh, that's easy! To ensure that a multiword search query is treated as a single phrase simply replace spaces with the + symbol in the input box. 😊

  • @borreguito1986
    @borreguito1986 2 หลายเดือนก่อน +1

    How i can search multiple data in chrome?