Forum Discussion
neha_sharma
12 years agoContributor
Hi Veronica,
You can try this:
set ddtobj = DDT.ExcelDriver(Ppath & "User_Info\plan_user.xls","infotwo")
Do While ddtobj.EOF = False
project.variables.var1= ddtobj.Value(4)
ddtobj.Next
loop
Call DDT.CloseDriver(ddtobj.Name)
You can try this:
set ddtobj = DDT.ExcelDriver(Ppath & "User_Info\plan_user.xls","infotwo")
Do While ddtobj.EOF = False
project.variables.var1= ddtobj.Value(4)
ddtobj.Next
loop
Call DDT.CloseDriver(ddtobj.Name)