The next version of Excel should allow web queries to login to a web site and
then extract data from the page. My company has an internal site but it has
a security wrapper around this website. I would like to pull data off of
this site but I can not do it easliy because of the login. I can open the
web query and login before I extract the data, but it is time consuming. It
should allow for a pop up window with a user name and password to be tied to
two corisponding fields on the web page. That should be submited and then
the web query extract data from the resulting page.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.
www.microsoft.com/office/comm...et.f unctions
- Dec 25 Tue 2007 20:41
Excel Web Queiries should work with protected web sites.
close
全站熱搜
留言列表
發表留言