Data Query/Feed

[Guest]

Does anyone have any knowledge about feeding a spreadsheet with real-time/live data from a the web, when the site has password protection? In other words, I would like to draw real-time data into a spreadsheet from a website that requires the user to log-on with a username and password in order to view the data. Is there some way to accomplish this, even if it means doing some "behind the scenes" work on either end? Advice appreciated...

 

[Corni]

You cannot get everything for free in this world. The fact that the site is PWD protected and requires a login speaks for itself. Will be not far when we are going to start paying for more services and accessing certain data. The internet access as runs today is not sustainable in the long run. Sorry to dissapoint.

 

[Legacy 98055]

Are you familiar with ADO Data Control in VB?
It can be used to make a connection assuming that you have a password and username.
A project such as this is beyond the scope of a little help from a message board.
If you would like to learn more about it, search Microsoft's website for ADO
Active Data Objects
It is not difficult to use if you are already aquainted with VB.
To see if it is installed on your computer, it probably is, search for this file:
I have only used this control in stand alone versions of VB and not with Excel, but it is included with Office 2000.

Typical location:
C:WindowsSystem
MSADODC.ocx
This message was edited by TsTom on 2002-03-24 09:15

 

[Legacy 98055]

Check this out as well:

http://www.15seconds.com/issue/991021.htm