Code issue

[1981.madhu@gmail.com]

Thanks to all.My code is resolved.Closing the Thread.

[/color]

[Saket]

Always make a habbit to put your solutions here. that may help others.

[1981.madhu@gmail.com]

Really i forgot .Simple i forgaot to giving the sheet name on excel sheet .By default its take sheet1 ,but i given sheet2.

Code:

datatable.AddSheet("newsheet")
datatable.ImportSheet "c:\tdf\spreadsheet.xls","[color=#FF0000]sheet2[/color]","newsheet"
n=datatable.GetSheet("newsheet").getrowcount
For i = 1 to n
datatable.SetCurrentRow(i)
flag=datatable.value("Flag","newsheet")
If flag = "y" Then
scriptpath=datatable.Value("Script_Path","newsheet")
objpath=datatable.Value("Repository_Path","newsheet")


executefile scriptpath


End If
Next