+ Reply to Thread
Results 1 to 8 of 8

VBA- Automate web query on password protected site

  1. #1
    Registered User
    Join Date
    08-11-2016
    Location
    United States
    MS-Off Ver
    2007
    Posts
    2

    VBA- Automate web query on password protected site

    Hi all!

    I have access to a website that contains data on companies with a download to excel option. You search an id number or the company name in the site and then you can choose the data points you want and export to excel. Now I have 10s of thousands of these id numbers and am looking to automate this using VBA. I did the first 1000 manually by searching the id number then exporting to excel, copying into my main spreadsheet.

    I have a very basic knowledge of VBA but I have used it a bit before. Is this even possible to automate through VBA or am I wasting my time?

    So to sum up, I am looking to automatically lookup the id numbers I have saved in excel and pull the data that is exportable from the password protected site back into my main spreadsheet.

    Any help would be greatly appreciated!!!

    Thanks!

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: VBA- Automate web query on password protected site

    Yes, it's quite straightforward but it's nigh on impossible unless we have access to the site or you're nifty with VBA and HTML

  3. #3
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: VBA- Automate web query on password protected site

    Yes and No,
    We need to look at the structure of the HTML from the source view, that is, how the password is identified in the document- most likely is part of a form, but as the site is password protected, unless you have basic understanding of HTML, you will struggle.
    No one will help, I am afraid, as we do not have the log-in permission.
    You can post the URL and will try to work out if one can figure out and then you can change the password yourself. The password will be included as a part of the code.
    If the site in intranet, then no chance.

  4. #4
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: VBA- Automate web query on password protected site

    Hi Kyle,
    I did not see your post. Blame IE

  5. #5
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: VBA- Automate web query on password protected site

    Haha maybe I was just too swift!

  6. #6
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: VBA- Automate web query on password protected site

    Quote Originally Posted by Kyle123 View Post
    Haha maybe I was just too swift!
    You might be using Chrome

  7. #7
    Registered User
    Join Date
    08-11-2016
    Location
    United States
    MS-Off Ver
    2007
    Posts
    2

    Re: VBA- Automate web query on password protected site

    This is the site I am trying to use. http://www.larkspurdata.com/client-log-in/

    I've done some basic python coding with website APIs before. I've just never done anything really with VBA and a little lost with the commands. Does having the website have a download to excel option make this more simple or would I still have to scrape the data from the site.

    Thanks again!

  8. #8
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: VBA- Automate web query on password protected site

    It depends on the page. You should be able to send an authenticated request to the site and download the Excel file directly - that said it may not be that straightforward. It's impossible to say though I'm afraid without access

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 03-08-2012, 01:34 AM
  2. Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  3. Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  4. Replies: 0
    Last Post: 09-06-2005, 07:05 AM
  5. Replies: 0
    Last Post: 09-06-2005, 04:05 AM
  6. Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  7. Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  8. Replies: 0
    Last Post: 09-05-2005, 10:05 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1