05-23-2012, 02:21 AM
'this is the column of the webtable that has the link in it - stored in the datatable
'name of the link to click = cell value of top cell of testing column
'**********You may be able to substitute .getroproperty "name" (or whatever unique identifier) for getcelldata********
'puts name of link in datatable
'name of column
The last line is the generic link I was talking about. It is a link whose text property is the "Column_Name" of the datatable. All I have to do is put each column number in the datatable and it will automatically pull the name of the link from the first cell, and click the link with that name.
Basically this is an alternative to using regular expression and not exactly the same thing, so I am not sure if it will help. If you aren't using a table, you may be able to use getroproperty instead of getcelldata to get what you need.
Code:
ncolumn = DataTable("Column_Testing", dtGlobalSheet)
'name of the link to click = cell value of top cell of testing column
'**********You may be able to substitute .getroproperty "name" (or whatever unique identifier) for getcelldata********
Code:
label = Browser("your browser").Page("your page").WebTable("Top Grid (date created and filter rows)").GetCellData(1, ncolumn)
'puts name of link in datatable
Code:
DataTable("Column_Name", dtGlobalSheet) = label
'name of column
Code:
Browser("your browser").Page("your page").Link("Column Name").Click
Basically this is an alternative to using regular expression and not exactly the same thing, so I am not sure if it will help. If you aren't using a table, you may be able to use getroproperty instead of getcelldata to get what you need.