Say I wanted to do a web query of a fictional website called sports.com/lookup?
But after the word "lookup" I want to insert the value from A1. IOW if the word in A1 is "player" then the web query that I want searched should be sports.com/lookup?player
If I record a macros of me simply going to sports.com/lookup? then the relevant part looks like this:
What do I do so that it adds A1 to the URL?With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://www.sports.com/lookup?", Destination:=Range("$A$4"))
Thank you for any help.