Querytables.add - Destination variable?

[Spurious]

Hello,

is it possible to save the output from querytables.add into a variable instead of a range?

And what comment do I need to use to get the source code from a website?

Thanks in advance!

 

[Spurious]

Anyone?

 

[Spurious]

One more bump.

 

[John_w]

is it possible to save the output from querytables.add into a variable instead of a range?

Not directly, because the Destination must be a range. But then you could copy (assign) the range data to a variable, achieving what you want.

And what comment do I need to use to get the source code from a website?

I don't understand what you mean by 'comment'. A web query can't get the source code, only table data.

 

[Rasm]

Try this-untested - dont use pivot tables.

Dim Avar() as variant

Avar=your output ' This should work - the array will be minimun 2 diminsional - most likely starting with element (1,1).


then add a breakpoint and turn on your Locals Window. If you have not used Breakpoints just place STOP in next line- run the code - when it stops - then go to view (on code section) on top - then select Locals Window - now go see the values in Avar