Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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] |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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] |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Data from HTTPS | Links and Linking in Excel | |||
Excel and HTTPS. | Excel Discussion (Misc queries) | |||
Unable to open webpage error during a web query to https site | Excel Discussion (Misc queries) | |||
Excel 2000: Web Query not working for https site | Excel Programming | |||
MS QUERY w/out querytable | Excel Programming |