Data Query/Feed
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Data Query/Feed

  1. #1
    Guest

    Default

     
    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...

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Brampton
    Posts
    328
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com