Use VBA and Hyperlink to return a search query

[PatrickMinto]

Using VBA is it possible to use a hyperlink to search a webpage with search input from an excel sheet ?

The idea is to use VBA to open a hyperlink and input relevant player information into the search area of the web page and return the player's handicap into the relevant cell in my spreadsheet??

Golfers handicaps are available to anyone

Thank you

[vba_php]

the most simplistic way to do this is probably a moot point in this day in age, because MS has forced users do use Edge instead of IE. however, you can give it a try:

https://www.access-programmers.co.uk...ng-vba.176968/

the better way to to do it would be to issue an XML-HTTP response text call. see the following for a recent discussion of that between me and someone else:

https://www.excelforum.com/excel-pro...turn-data.html

also see here:

https://docs.microsoft.com/en-us/pre...62275(v=vs.85)