Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Downloading Worksheets
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Downloading Worksheets | Excel Programming | |||
DOWNLOADING TEMPLATES | New Users to Excel | |||
Downloading from Bloomberg! | Excel Discussion (Misc queries) | |||
CALCULATING WORKSHEETS (INCLUDING AGE CALCULATING SHEETS) FOR DOWNLOADING, GREAT FOR PENSIONS/LIFE INSURANCE CALCULATIONS! | Excel Programming | |||
downloading excell from web | New Users to Excel |