Hi,
I was learning about web queries for a small project. I wanted a value
taken from a web page to be showed in a textbox in a form.

I recorded the steps to create the web query to dump the data in a sheet
and it worked. It's kind of a table, but I need just one data (always in
the same cell). So first question: Is it possible to get data and no
needing to put in a sheet first? (remember I need it in a form textbox)

As I didn't find another way to do this, I tried using a very hidden
sheet (which was already in use by other procedures). The problem is
that now the query doesn't let me put the data in another sheet that is
not the active sheet. Second question: Any workaround to this problem?

Finally the only solution I see is, by code, unhide the very hidden
sheet, switch to it, do the web query, then go back to the previous
active sheet, re hide the very hidden sheet and continue working. All
this "hidden" behind "Application.ScreenUpdating=False".

Is there any better solutions to this?

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.