+ Reply to Thread
Results 1 to 11 of 11

Website login

  1. #1
    Registered User
    Join Date
    07-19-2011
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    73

    Website login

    How can I setup a macro in Excel that runs in the background that will go to this website https://login.salesforce.com/ login with my user name and password? I just need to be able to cache the website logged in so that I can run my other macro that will pull data from the site.

  2. #2
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: Website login

    It can be done. Have you ever used VBA to automate web browsers before? If not, a few google searches will give you some good tutorials to get you started - I can help out when you get stuck.
    *******************************************************

    HELP WANTED! (Links to Forum threads)
    Trying to create reusable code for Custom Events at Workbook (not Application) level

    *******************************************************

  3. #3
    Registered User
    Join Date
    07-19-2011
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    73

    Re: Website login

    This was actually more of a rush request and was hoping someone had a quick answer for this.

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

    Re: Website login

    There isn't a quick answer to this I'm afraid

  5. #5
    Registered User
    Join Date
    07-19-2011
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    73

    Re: Website login

    Well, if anyone has an idea on how to do this, I would appreciate the help, thanks in advance.

  6. #6
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    7,213

    Post Re: Website login


    Automate Internet Explorer

    ______________________
    Je suis Charlie
    Last edited by Marc L; 01-19-2015 at 08:17 AM.

  7. #7
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: Website login

    Below may help get you started. You will need to enable reference library Microsoft Internet Controls

    Disclaimer - this is untested as I dont have a SalesForce account and IE is not displaying the login page correctly for me (unlike Chrome but I cant automate Chrome yet as I havent time to check out Selenium)

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

  8. #8
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Website login

    Just a note of caution. It is fine to use early binding on your own machine, i.e. adding a reference to a specific library.

    Your code may show a different version than user has. If the user is not software savvy, he or she may not load the correct version as older versions often remain behind after system updates. The code will then of course fail. The reason for using late binding, like CreateObject, is the user's machine will always load the correct library automatically.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  9. #9
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: Website login

    Quote Originally Posted by Leith Ross View Post
    Just a note of caution. It is fine to use early binding on your own machine, i.e. adding a reference to a specific library.

    Your code may show a different version than user has. If the user is not software savvy, he or she may not load the correct version as older versions often remain behind after system updates. The code will then of course fail. The reason for using late binding, like CreateObject, is the user's machine will always load the correct library automatically.
    Is there more than one version of 'Microsoft Internet Controls'? The one I'm using doesn't have a version number.
    Last edited by mc84excel; 01-22-2015 at 06:30 PM.

  10. #10
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: Website login

    Quote Originally Posted by stangz71 View Post
    Well, if anyone has an idea on how to do this, I would appreciate the help, thanks in advance.
    Did the code I posted work for you? If it didn't, I'd be interested in knowing where it failed. If it did work, please mark the thread as solved.

  11. #11
    Registered User
    Join Date
    01-28-2015
    Location
    Earth
    MS-Off Ver
    2013
    Posts
    1

    Re: Website login

    Quote Originally Posted by stangz71 View Post
    This was actually more of a rush request and was hoping someone had a quick answer for this.
    In other words can someone do it for me for free...
    @mc84excel don't hold your breath.

+ 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] VBA To login to a website
    By Sun13Banjo in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-06-2015, 10:46 AM
  2. Login into website
    By jharaldson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-10-2013, 10:55 AM
  3. [SOLVED] VBA to Login to website
    By IanHyman in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-28-2013, 03:27 PM
  4. Using vba to login into a website
    By Jack7774 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-08-2013, 11:35 AM
  5. website login through vba
    By abousetta in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-04-2012, 09:32 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