• Click on Record button.
• Go to the website http://www.hcad.org
• Type in 13 digit Account number for e.g. 1186820010001 in the Account number box.
• Hit enter or click on 'Search' button
• In the search page, copy the information like property name, address, land area, building area, etc using your mouse and paste it in the Excel one by one.
• Hit the Back button on your browser window once you are done copying results for one Account number.

• Using Variable Manager, create a variable called 'AccountNumber' of type List.
• Specify to read the values from a text file.
• Specify the path of the text file as C:\AccountNumber.txt.
• Specify the list of account numbers in the text file as shown in Screenshot 1

• The recorded task will extract the information for one account number.
• To make your task extract the information for the list of account numbers you will need to modify the recorded task.
• Select the task and click on 'Edit' to open it in editor.
• Insert a Loop for List around the recorded action. You have to Loop for the list of values present in the AccountNumber List variable.
• Double-click the line where you see your account number being typed (1186820010001) and replace it with the list variable $AccountNumber$.
• The modified task will look as shown in Screenshot 2

Tip:

• You will repeat your actions in a loop. So before the loop ends, make sure that the cursor in Excel is in the appropriate cell.
• The resultant Excel file could look as shown in Screenshot 3

Note:

• The recorded task depends on the mouse co-ordinates for copying the data. If your search results support copying using the keyboard shortcuts use that as keyboard shortcuts can work in any screen resolution.