+ Reply to Thread
Results 1 to 2 of 2

Entering ID/Password using VBA

  1. #1
    Registered User
    Join Date
    09-14-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2013
    Posts
    1

    Entering ID/Password using VBA

    Hi all,

    Forgive the simple question, but I'm a bit new to programming still.

    I'm trying to open up a webpage and enter in an ID and password, copy all data, and paste into my sheet. This is the code I have so far, I'm not sure where to go from here!


    Please Login or Register  to view this content.

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

    Re: Entering ID/Password using VBA

    I do not think any site will allow to parse username and password as parameters using "Get" Method. The main reason for not using the "Get" method is to prevent sensitive data posted in to the URL, so anyone can see your password.
    You have two options:
    1. Find Username and password tag elements and assign the username and password values to each element.
    2. You can use the "Post" method using HTTP request.
    I am of course assuming you have some basic knowledge of HTML and web scrapping.
    You are unlikely to get help as we do not have access to the source data, and can not see the source view for password and username.

+ 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. [SOLVED] entering certain cell value protected by a password
    By jomsborczyk in forum Excel Programming / VBA / Macros
    Replies: 28
    Last Post: 06-01-2017, 10:51 AM
  2. Entering password that refreshes data from FTP macro
    By San75 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2016, 09:11 PM
  3. Ask for password before entering data into cell
    By superchew in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-26-2014, 08:57 PM
  4. UNHIDE Columns by entering password
    By meadmoon in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-23-2013, 10:48 AM
  5. Viewing rows by entering password
    By funfgrunf in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 03-22-2012, 09:50 PM
  6. after entering certain number of times wrong password file can cur
    By Rao Ratan Singh in forum Excel General
    Replies: 1
    Last Post: 08-28-2005, 12:05 PM
  7. [SOLVED] How to keep users from entering a password on a shared workbook?
    By alady31 in forum Excel General
    Replies: 1
    Last Post: 03-24-2005, 02:06 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