Dave,
It depends on how the web site has written the HTML/Scripting to construct
the web page.
It would seem that Excel is unable to determine where the data is, because
the HTML does not appear to contain tables. This may be because the site
does not want to facilitate automated access to its pages.
Depending how the web site is set up, you may be able use the URL to send
the login and/or filename data. e.g.
http://TheWebite.com/somepage.html?u...=yourexcel.xls
Otherwise you work with the web page/server with an instance of IE or
WinHttp (MS WinHTTP Services)
The specific time part should be easy using the Control PanelScheduled
Tasks within Windows.
NickHK
"Dave" wrote in message
...
The website I am trying to import the data from does have the "yellow"
arrows
next it in the Web-Query browser. Do you know what this problem could be?
Thanks.
"John Bundy" wrote:
Do a web-query and under the query properties you can set how often to
refresh the data. For more options you can do this through code if
needed.
--
-John Northwest11
Please rate when your question is answered to help us and others know
what
is helpful.
"Dave" wrote:
Is it possible to have Excel download an excel sheet from a
password-protected website at specific times during the day? The URL
will
not change, nor the filename. Thanks.