Data Query/Feed

Mar 1st, 2002, 08:51 AM

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 · Mar 24th, 2002, 09:58 AM

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.

Tom Schreiner · Mar 24th, 2002, 10:13 AM

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 ]

Tom Schreiner · Mar 24th, 2002, 12:25 PM

Check this out as well:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 1st, 2002, 08:51 AM	#1
Guest Posts: n/a	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...

Mar 24th, 2002, 09:58 AM	#2
Corni Board Regular Join Date: Mar 2002 Location: Brampton Posts: 324	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.

Mar 24th, 2002, 10:13 AM	#3
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	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 ]

Mar 24th, 2002, 12:25 PM	#4
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Check this out as well: http://www.15seconds.com/issue/991021.htm