Search
 
 

Display results as :
 


Rechercher Advanced Search

Latest topics
» FlexMonkium Download Not available under Gorillalogic site
Thu Dec 08, 2016 5:40 pm by bhanu.praveen

» Selenium Script issue
Tue Dec 06, 2016 9:48 pm by njain213

» Difference between QTP, Selenium and Silk test
Tue Dec 06, 2016 7:58 pm by jessicacyrus1

» Where does selenium script pick browser from
Tue Dec 06, 2016 1:52 pm by janbaskt

» Safari throws an HTTP ERROR: 404
Tue Dec 06, 2016 1:51 pm by janbaskt

» Access Denied Error in Selenium RC
Tue Dec 06, 2016 1:51 pm by janbaskt

» Automating Flex application through selenium webdriver
Fri Dec 02, 2016 2:06 pm by abhinay.krs

» Starting with Selenium, what is Selenium?
Mon Nov 28, 2016 4:00 pm by Foma

» Getting started with Selenium
Mon Nov 28, 2016 3:23 pm by Rebbelx

Navigation
 Portal
 Index
 Memberlist
 Profile
 FAQ
 Search

VBA Macro for already open Firefox(with installed Selenium)

View previous topic View next topic Go down

VBA Macro for already open Firefox(with installed Selenium)

Post by mynameissaturn on Thu Apr 30, 2015 10:42 pm

Hi,

I am new in Selenium.

Is there someone who could help me with this?

This time I am using Firefox (with installed Selenium) with already opened Website titled "All Incoming Work Requests". I also have Activity ID's on excel column A and Employee numbers on excel column B.

Column A        Column B
1-14VOW19    ACAB3024
1-14VPK3E      ACAB3007
1-14VPJP9      ACAB3008
1-14VR0NX     ACATB3017
1-14VP388     ACATB3013


What I want to do is,

1. Click the Query button (button id="s_1_1_21_0_Ctrl") on the website.
(Then wait for the site to be completely loaded. Approx 1-2 seconds to load)
2. Copy the 1st Activity ID on excel Column A.
3. Select the Activity ID field on the website (input id="1_Activity_Id") and paste the Activity ID that was copied from excel.
4. Copy the 1st Employee number on excel Column B.
5. Select the Owner field on the website (input id="1_Owned_By") and paste the Employee number that was copied from excel.
6. Then click the GO button on the website (button id="s_1_1_20_0_Ctrl") so that the Activity ID will be assigned to the employee.
(Then wait for the site to be completely loaded. Approx 1-2 seconds to load)
7. Again back to step number 1 and loop this process until all the data on column A and column B are done.

This will be use for Dispatching Works automatically. This process consumes so much time and effort on manually assigning more than a hundred of Activity IDs daily.

Hoping to here from you.

Thanks a lot!

mynameissaturn

Posts : 1
Join date : 2015-04-30

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum