You use your variable mystr
in this line -
With ActiveSheet.QueryTables.Add(Connection:=mystr, Destination:=Range("$A$1"))
mystr = "URL;http://apps.webofknowledge.com.ezproxy1.lib.asu.edu/Search.do?product=WOS&SID=1BzJbqm9xDW5Yzj4rhB&search_mode=GeneralSearch&prID=44dc4b3a-138a-4532-8429-772860bea673"
But then you redefine it before calling it in the querytables.add
method -
mystr = Cells(x, 1)
So, now it's
With ActiveSheet.QueryTables.Add(Connection:=Cells(x, 1), Destination:=Range("$A$1"))
Unless cells(x,1) has the correct format for the querytables.add
method, it won't know what to do.
You also haven't seemed to declare any of your variables, so I'm not sure what they are.