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.
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
*******************************************************
This was actually more of a rush request and was hoping someone had a quick answer for this.
There isn't a quick answer to this I'm afraid
Well, if anyone has an idea on how to do this, I would appreciate the help, thanks in advance.
Re: Website login
Last edited by Marc L; 01-19-2015 at 08:17 AM.
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.
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 Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Is there more than one version of 'Microsoft Internet Controls'?Originally Posted by Leith Ross
The one I'm using doesn't have a version number.
Last edited by mc84excel; 01-22-2015 at 06:30 PM.
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.
In other words can someone do it for me for free...
@mc84excel don't hold your breath.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks