Use a user input as a variable to search from a excel file and get a related data (URL) and open the url in a browser. RRS feed

  • Question

  • Hi Guys,

    I am not able to go through the below mentioned situation inspite of several attempts. Please help to make this part.

    The scenario is as follows:

    First, I want to take a user input  as a variable.

    Second, I have a excel file....I want to open the excel file.

    It has 4 columns and it looks like this:

    ID   URL                             Username    Password

    ab            zubi             zubi1

    a9     rubi             rubi1

    The user input should be anything from the ID column. Hence the script should use the user input (say for example user inputs a9) to search the same excel sheet ......pull the relative URL from second column and open it in a browser and then pull the relative Username and Password from the 3rd and 4th column and login to the website.

    So here if user inputs a9 should open up and use "rubi" & "rubi1" as user name and password respectively to login.

    Please help me with this. Thanks in advance.

    Thursday, July 10, 2014 2:12 PM