03-24-2009, 05:02 PM
Hi,
I think you can try this.
Initialize the excel object DOM and pass the link name as the parameter to the action.
I think you can try this.
Initialize the excel object DOM and pass the link name as the parameter to the action.
Code:
Set excel = createobject("excel.application")
excel.visible=false
Set obook=excel.workbooks.open("C:\test.xls")
Set osheet = obook.worksheets(1)
LinkName=osheet.cells (2,13).value
Set oDesc = Description.Create()
oDesc("name").Value = "{Link Name}"
Browser("Browser").Page("Page").Link(oDesc).Click