Hi Helen,
Thank you very much for the code you provided.
I need some more suggestion to the code you provided below...
1) Instead of using the row loop directly in the subroutine, I want to make this loop run in a separate subroutine and call the subroutine to input the data into the application.
2) Is it possible to use loop for column also in the below code? For column value; instead of giving excel cell reference as 1, 2 etc, can we give J as reference, the way it is done for row, taking 'i'?
3) OR can we use the string to store row and column values and call the string in the subroutine to input the data, which I use to do in my code provided in my first mail at the top?
Could you please help me in this regard?
VBScript
Sub createbudget
Dim Rightframe, Excel, i
Set Excel = Sys.OleObject("Excel.Application")
Call Excel.Workbooks.Open("E:\Budget.xlsx")
Delay 1000
Set Rightframe = sys.process.page("http//").document.rightframe
For i = 1 to 4
RightFrame.document.all.Item("ddlProj").ClickItem( VarToString(Excel.Cells(i, 1)) )
RightFrame.document.all.Item("ddlSubProj").ClickItem( VarToString(Excel.Cells(i, 2)) )
Next
' Closes the driver
Call Excel.ActiveWorkbook.Save
Call Excel.Workbooks.Close
End Sub
