ChloeRadshaw
10-30-2008, 06:47 PM
Hi All ,
I need to connect to a URL and retrieve data which I then want to process in VBA.
As far as I understand it web queries is the way to do this and I have written the code to do this - However this relies on writing the webquery results to a range
Is here any way og getting the web query to return data into memory and not have to use a worksheet as an intermediate step?
Any answers much appreciated
I need to connect to a URL and retrieve data which I then want to process in VBA.
As far as I understand it web queries is the way to do this and I have written the code to do this - However this relies on writing the webquery results to a range
Is here any way og getting the web query to return data into memory and not have to use a worksheet as an intermediate step?
Any answers much appreciated