I am using PAD to read data from 20 Excel lists (from same Excel sheet) that each contain a list of text strings.
Each of the 20 lists is stored as List1, List2, List3 etc in PAD. The reason for making 20 lists is because the website I am posting the list to can only fit 50 records in the text field, and I want to check 1000 records (so I have 20 lists of 50 records each).
I also made a list of numbers 1-20 that is read by PAD and stored as "ExcelLists", to be used as a variable (CurrentItem) in my For Each loop.
Now I'm trying to create a For Each loop which, for each CurrentItem in ExcelLists:
- Launches a new browser instance (using same URL), to be stored as Browser+CurrentItem (so Browser1, Browser2 etc..)
- Goes to a text field in the newly launched browser and pastes the text strings from List+CurrentItem (so List1, List2 etc..)
I can do almost everything correctly but pasting the text (List1, List2 ....etc) is proving difficult. I dont like to use the "Populate" functions in PAD as they take a long time to fill long lists into a field. Instead I prefer to set the clipboard text to my dataset and then just paste it (instantly) in the website field, this approach is much faster.
After the browser launches and I go to the text box, I am trying to set the clipboard text to each List1, List2 etc by using "List+CurrentItem" but I cannot seem to successfully combine "List" with CurrentItem in a way that will correctly send List1, List2, List3 etc to the Clipboard (to then be pasted into the website text field. Also not sure if the similar approach I am using to label each new Browser version is correct (so they get labled Browser1, Browser 2 etc).
Not necessary but very nice to have would be to merge all of the 20 Browser versions into 1 browser (with 20 different tabs) but unsure how to do this. Currently the appear as 20 seperate browser instances.
