Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Import Variables from Excel; Select Object by ObjectID
#1
Two questions please:

I'm just now starting my trial period. I keep trying different company's products - I sure hope yours fits the bill!

1. Can I select object in Google's Chrome browser by object name instead of location or by image? I'm tired of mucking around with image recognition and the problems it causes when the screen is set to different zoom levels.

2. I have 1 excel document that has an undetermined number of variables in it (varying number of variables). I need the program to figure out how many there are and run a loop for each one. This document has 2 sheets. The first sheet has two columns, UserID and Password. The second sheet has the list of the URLs. Both of these sheets have an variable number of entries. Can this program inport each sheet, presumably as an array, and then execute the code based upon the data in those sheets? Is there a sample I could look at?

Basically, the code I am looking at is pretty simple and would:

Code:
Copy      Help
Open Excel (csv text file would also work if needed or quicker) and copy each sheet as a data set of variables
Close Excel
Open Browser
Loop1 For Each Row in Sheet 1 (UserID & Password)
   Signin, pause for manual entry, continue
      Loop2 For Each Row in Sheet 2 (URL list)
         Perform various actions on screen in browser by selection of objects
      End Loop2
   Log Out
End Loop1
Close Browser

Finally, do you happen to have any videos of your product that I can watch?

Thanks for your help,


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)