Posting data from worksheet to webquery ??

[fsensible]

Can anyone tell me some macro code to send data from say cell A10 to a
web query to be placed in sheet2 in cell A1 if it's possible.

The webquery page would be something like http://localhost/test.php?query=(text
in cell A10 sheet1)

Thanks

 

[Vergel Adriano]

here's one way:

Dim qry As QueryTable
With Sheets("Sheet2")
Set qry =
..QueryTables.Add(Connection:="URL;http://localhost/test.php?query=" &
Sheets("Sheet1").Range("A10").Text, Destination:=.Range("A1"))
qry.Refresh
End With

 

[fsensible]

Thanks for that Vergel it works a treat.