Excel Web Query using a QueryTable via HTTPS??

[Guest]

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

 

[Jake Marx]

Hi Bing,

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]

 

[Guest]

Hi Jake,

Thanks! That was very helpful info.

Cheers,
Bing

Hi Bing,

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]