+ Reply to Thread
Results 1 to 4 of 4

Data Scraping Password Protected websites

  1. 12-03-2014, 04:31 PM #1
    ChristopherBrandonKi is offline
    Registered User
    Join Date
    11-21-2014
    Location
    Dalton, GA
    MS-Off Ver
    2010
    Posts
    13

    Data Scraping Password Protected websites

    Hello,

    I am mid-level at VBA and have created several useful macros to make my job easier. I am still stuck manually getting data from websites and was looking into pulling the data from different resources automatically. Unfortunately, every site I use is password protected so it isn't as simple as just using the excel data pulling application. My main question is, does anyone know where I can find a good tutorial on "data scraping" that can be used with password protected websites? I've been looking on google and youtube but I can only find very few examples and no one really "teaching it", just a few random and difficult to understand examples.


    Any ideas?
    Reply With QuoteRegister To Reply
  2. 12-03-2014, 04:32 PM #2
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,049

    Re: Data Scraping Password Protected websites

    OP pm'd me to say they have the passwords for these sites, so the thread has been reopened
    Last edited by FDibbins; 12-03-2014 at 04:47 PM.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 12-03-2014, 04:54 PM #3
    ChristopherBrandonKi is offline
    Registered User
    Join Date
    11-21-2014
    Location
    Dalton, GA
    MS-Off Ver
    2010
    Posts
    13

    Re: Data Scraping Password Protected websites

    I apologize for not clarifying this.

    This is for me to logon to websites where I have my very own login information, I simply want to automate that process because manually it can be very time consuming. I just need to be able to tell VBA to go to that website and use my login information and then pull the same types of reports that I have to get daily, weekly, or monthly depending on the report I am needing. I just don't know where to start.

    I am willing to research it for myself, I just was hoping someone may be able to point me in the right direction.
    Last edited by ChristopherBrandonKi; 12-03-2014 at 04:58 PM.
    Reply With QuoteRegister To Reply
  4. 12-03-2014, 05:00 PM #4
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,049

    Re: Data Scraping Password Protected websites

    Thanks for the update
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Extracting data from password protected worksheet that has linked password protected data
    By KEAnderson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-19-2014, 10:02 PM
  2. Web Query for password protected websites
    By raven123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-10-2014, 05:35 PM
  3. VBA to get password protected web page data
    By sixthscroll in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-03-2013, 07:43 PM
  4. getting data from a password protected database
    By adnan buran in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-16-2007, 09:15 AM
  5. how to retrieve data from password protected web pages?
    By Hakki in forum Excel General
    Replies: 0
    Last Post: 09-09-2005, 01:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1