Excel Web Query using a QueryTable via HTTPS??
Hello,
Was wondering if anyone knows of any tools/methods/alternatives in using excel's native Querytable HTTP functionality to retrieve data from the internet to populate worksheet but HTTP request is TUNNELLED thru HTTPS? Thanks Bing |
Excel Web Query using a QueryTable via HTTPS??
Hi Bing,
Bing wrote: Was wondering if anyone knows of any tools/methods/alternatives in using excel's native Querytable HTTP functionality to retrieve data from the internet to populate worksheet but HTTP request is TUNNELLED thru HTTPS? There are a few alternatives: 1) use the XMLHTTP object 2) automate the InternetExplorer application Alternative #1 is generally quicker and simpler, but #2 may offer you some more flexibility. If you do a google groups search on XMLHTTP or InternetExplorer, you'll find lots of info on how to do it. -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] |
Excel Web Query using a QueryTable via HTTPS??
Hi Jake,
Thanks! That was very helpful info. Cheers, Bing "Jake Marx" wrote: Hi Bing, Bing wrote: Was wondering if anyone knows of any tools/methods/alternatives in using excel's native Querytable HTTP functionality to retrieve data from the internet to populate worksheet but HTTP request is TUNNELLED thru HTTPS? There are a few alternatives: 1) use the XMLHTTP object 2) automate the InternetExplorer application Alternative #1 is generally quicker and simpler, but #2 may offer you some more flexibility. If you do a google groups search on XMLHTTP or InternetExplorer, you'll find lots of info on how to do it. -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] |
All times are GMT +1. The time now is 03:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com