Hi ,
I have excel sheet name as Book4.xls,in that 1 sheet having the Coulmn names as Script_Path,Repository_Path,Flag.
Script_path is nothing that iam giving the path of the my .vbs file and Repositopry _path is my repository path(.tsr file) and Flag value either "y " or "n".if flag="y".
***//Pls help me,and correct the code
wen ever executing this script getting eroor as " expecting "if"
and as well as well how to add objpath to specific scriptth path ?
I have excel sheet name as Book4.xls,in that 1 sheet having the Coulmn names as Script_Path,Repository_Path,Flag.
Script_path is nothing that iam giving the path of the my .vbs file and Repositopry _path is my repository path(.tsr file) and Flag value either "y " or "n".if flag="y".
Code:
datatable.AddSheet("newsheet")
datatable.ImportSheet "c:\tdf\spreadsheet.xls","sheet1","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***//Pls help me,and correct the code
wen ever executing this script getting eroor as " expecting "if"
and as well as well how to add objpath to specific scriptth path ?