Thanks. However I do not know if this is the solution to my problem so
I will explain further.

Currently I have VBA that opens a web page, and using sendkeys submits
data to the page to open another page. It is on this second page that
I automatically want the code to copy some information back into
excel, then close the web page. I can see that the web query works but
can I put this query into my code or is there another way of coding it?