![]() |
WebQuery to Array?
Is it possible in VBA to send the results of a WebQuery to an array rather than to a range? If so, how? By the way, I don't want to send the results to a range and then to an array. Instead, I want to send the results directly to an array. Thanks. Charley |
WebQuery to Array?
I would say not using a standard web query.
-- Regards, Tom Ogilvy "Charley Kyd" <kyd at incsight dot com wrote in message ... Is it possible in VBA to send the results of a WebQuery to an array rather than to a range? If so, how? By the way, I don't want to send the results to a range and then to an array. Instead, I want to send the results directly to an array. Thanks. Charley |
WebQuery to Array?
Tom, I'm intrigued by your "standard" qualifier. Is there a non-standard web query that would do this? Or do you mean that I would have to write my own version from scratch? If the latter, that would be very unfortunate, because WebQuery offers speed and convenience that I would hate to sacrifice. Thanks. Charley "Tom Ogilvy" wrote in message ... I would say not using a standard web query. -- Regards, Tom Ogilvy "Charley Kyd" <kyd at incsight dot com wrote in message ... Is it possible in VBA to send the results of a WebQuery to an array rather than to a range? If so, how? By the way, I don't want to send the results to a range and then to an array. Instead, I want to send the results directly to an array. Thanks. Charley |
WebQuery to Array?
I meant a query table returns data to a range. If you go outside that,
using automation or some other technology, then perhaps you can get something going. My intent was only to answer concerning a querytable. -- Regards, Tom Ogilvy "Charley Kyd" <kyd at incsight dot com wrote in message ... Tom, I'm intrigued by your "standard" qualifier. Is there a non-standard web query that would do this? Or do you mean that I would have to write my own version from scratch? If the latter, that would be very unfortunate, because WebQuery offers speed and convenience that I would hate to sacrifice. Thanks. Charley "Tom Ogilvy" wrote in message ... I would say not using a standard web query. -- Regards, Tom Ogilvy "Charley Kyd" <kyd at incsight dot com wrote in message ... Is it possible in VBA to send the results of a WebQuery to an array rather than to a range? If so, how? By the way, I don't want to send the results to a range and then to an array. Instead, I want to send the results directly to an array. Thanks. Charley |
All times are GMT +1. The time now is 05:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com