+ Reply to Thread
Results 1 to 8 of 8

Unable to Login to YES BANK Corporate website

  1. #1
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Unable to Login to YES BANK Corporate website

    Hi All

    i am unable to set a code to select Corporate & Click on Login of YES BANK, below is the link of YES BANK site and i want to set a code to get it happen

    http://www.yesbank.in/corporate-banking.html

    below is my code which i am using to get it happen & any help appreciate !!

    Please Login or Register  to view this content.
    Thanks - Naveed
    -----------------------------
    If the suggestion helps you, then Click * to Add Reputation
    To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
    1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

  2. #2
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Unable to Login to YES BANK Corporate website

    Bump ! anyone please look into this

  3. #3
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Unable to Login to YES BANK Corporate website

    Any Updates !!

  4. #4
    Forum Contributor codeslizer's Avatar
    Join Date
    05-28-2013
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2003 - 2010
    Posts
    245

    Re: Unable to Login to YES BANK Corporate website

    Hello Naveed,

    I've worked on your request and attached is a working sample. Let me know for any clarifications.
    ** Please note, this scripting is only for educational purposes. Because for some banks, these kind of scripting is not legal or good for them **

    The code in the attached file starts with a regular navigation to the website and selects the option button for Corporate. To accomplish this, it iterates through all <input> tags and checks if satisfies the following conditions:
    1. Type = "radio"
    2. Name = "loginType"
    3. Value = "CO".

    Then to press LOGIN button, I've directly run the javascript in the document (as it wasn't a control) using the following code:
    Please Login or Register  to view this content.
    This initiates a pop-up window which now sophisticates the automation process. That is till now, we've been referring to an IE document, say A, now we'll have to refer to another document B in another IE window. So, we've to now search for the right window. For this, we get a list of all windows opened using Windows Shell object. Steps involved would be -
    1. Getting IE windows list and
    2. checking their validity for each IE window, i.e., we've to verify if they are the right windows, if yes, then follow with our automation.

    This is done by the following code:

    Please Login or Register  to view this content.
    Once the document is referenced, we're clear on our objectives. Simply get the right controls, fill them up with right credentials and hit the login button (which is again an image and need "fLogon()" javascript to be run. There you go..

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by codeslizer; 01-24-2014 at 05:21 AM.
    cOdEsLiZeR - Back after a long break.. Let's sLiZe some more cOdEs!!

  5. #5
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Unable to Login to YES BANK Corporate website

    Hi cOdEsLiZeR,

    wow its realy very nice & wonderfull thanks for this & i have some question on this.

    its opening the browser and login window browser in new window but its not taking the login credential its giving msg as not detected

    can you please look into this and once again thanks

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

    Re: Unable to Login to YES BANK Corporate website

    Why not just navigate directly to www.yesbank.in/popup.php?type=CO and skip the whole popup handling thing?

  7. #7
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Unable to Login to YES BANK Corporate website

    @ Kyle123 - Its works perfectly like charm, Thank you very very much sir

    @ codeslicers - Thanks to you as well you also done a very big wonderfull job

    Thanks both of you , Its SOLVED....

  8. #8
    Forum Contributor codeslizer's Avatar
    Join Date
    05-28-2013
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2003 - 2010
    Posts
    245

    Re: Unable to Login to YES BANK Corporate website

    @Kyle - coz am yet to reach that level of yours.. :p Not used to work with IE automation, that's all.
    @Naveed - Glad to help, and thanks for the feedback and reps

+ 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. Login into website
    By jharaldson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-10-2013, 10:55 AM
  2. [SOLVED] VBA to Login to website
    By IanHyman in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-28-2013, 03:27 PM
  3. 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
  4. website login through vba
    By abousetta in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-04-2012, 09:32 PM
  5. Website login help
    By davemaddocks in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2011, 10:59 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