Extract data/ Extract table command abend

[maroblouna]

Hello,

I have a task that needs to Iterate through a series of clickable titles within a page, open the linked pages to the titles and extract data from those pages.
The titles are in a <ul> <li> list, not in a table, so I couln't use an AA loop to iterate through them . So I pasted the list in an excel sheet and looped through them (using a variable) and opened each linked page using an excel macro. However the Extract data & Extract table commands abend on the opened pages.

When I tried to override the macro and open one of the linked pages - hard coded- using the Navigate URL command, the extractions work fine, they only seem to abend when the page is opened through Excel.
The opened pages (through AA or through excel) have no obviious differences, however AA seems to discriminate them somehow.

How could I overcome this problem?
Thanks in advance,
M.

[forumsupport]

Hello,

Extract Data/ Extract Table command works if IE browser instance is opened by Web Recorder command. If you are using Excel macro to open the link in new IE window then Extract Data/ Extract Table command will not work in that IE window.

You can use Extract Data command to get the list of links. You can log them into a text file and then read that text file to click on each link.

We have attached a sample task for your reference. To run this task,

. Please copy attached .atmn under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder.
. Copy .xls files under C:\.
. Create variable, $Temp$ through Variable Manager.

To create variable please follow below mentioned steps,
1. Go to Tools->Variable Manager in Automation Anywhere.
2. Click on “Add New Variable”.
3. From "Type" dropdown, select "Value".
4. In “Name” field, enter “Temp”.
5. In “Value” field enter any value say 'x'.
6. Press “Save”
7. Press “Ok”

Hope that helps.