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]