webquery from hyperlink in cell via VBA

[jamiepullen]

Hi, i have a column of up to 30 cells (A2:A31, usually less though) on a sheet called 'links' that have a hyperlink in each cell. I then have up to 30 sheets that correspond to each cell eg 'sheet1'=A2, 'sheet2'=A3, 'sheet3'=A4, etc.

Is it possible to use code to have the sheet that corresponds to the hyperlink, display the webdata for that link so that if i alter that particular hyperlink in the cell, the sheet changes to the new web query?

I have looked on here and google and i think it is possible, but i cannot come up with any code as advanced as that (yet!!)

Regards, Jamie

[jamiepullen]

i have cracked it, just in case anyone else needs this at some point:

http://http://www.jkp-ads.com/articles/WebQuery.asp

regards,

Jamie