I'm stumped
I need to import data into excel via a web query. The problem is I
have to log in to get the information. Is there anyway I can make
excel query me for the login name and password and then get the data?
Eventually I plan to make this all through VBA but for now I'm just
trying to get the fundamentals down. Please help!
.
Relevant Pages
- Re: Web Query in Excel
... I think your colleague is correct. ... causing Excel some problems. ... modifying the HTML to remove the offending parts. ... then set up your web query to point to the local file and set it to ... (microsoft.public.excel.programming) - Re: Web Query in XL2004 ?
... When you run a web query, the External Data toolbar should automatically ... You can also try my free Excel template if you are not running Excel v.X ... (microsoft.public.mac.office.excel) - Re: Dynamic link to website
... I have used the following from MS Excel Help. ... queries are especially useful for retrieving data that is in tables or ... Create a new Web query ... so that the current value is listed every time I open the asset register? ... (microsoft.public.excel.worksheet.functions) - Re: Dynamic link to website
... I have used the following from MS Excel Help. ... queries are especially useful for retrieving data that is in tables or ... Create a new Web query ... so that the current value is listed every time I open the asset register? ... (microsoft.public.excel.worksheet.functions) - Re: Cleaning up Imported Text
... Base the chart on the date in columns B and C. ... > I wrote a web query to get text data from a Federal Reserve Bank site. ... Excel FAQ, Tips & Book List ... (microsoft.public.excel.charting) |
|