Parameterise the Cell coordinates for a Swf Table object

[neerukonda]

Hi All

I am in need of help for parameterising the cell coordinates. Instead of the coordinated I would like to read by name in the cell.

In breif the actions on my application are 1. double click on a particular security(cell data) to open that security properties window.

I am looking to pass the name of the security from the external data file say excel sheet.

Much more from attachment.

Any help is grately appreciated.

Many thnaks in advance
maruti

[savita.kale]

Hi Maruti,

Foollowign is the code to extract values from Excel sheet. It may help you.

Code:

Dim sFileLocation On Error Resume Next SystemUtil.CloseProcessByName "Excel.Exe" sFileLocation = "C:\Input.xls" sWorksheet = "InputData" Set xlObj = CreateObject("Excel.Application") xlObj.Visible = True Set xlWorkBookObj = xlObj.Workbooks.Open(sFileLocation) Set xlWorkSheetObj = xlWorkBookObj.Worksheets(sWorksheet) 'For 2 rows For i =2 To 3 sLiabilityValue = xlWorkSheetObj.Cells(i,1) SwfWindow("InvestmentManager - Automation").SwfWindow("Targeter - CDO Fund").SwfTable ("preTradesGrid").ActivateCell sLiabilityValue Next