Forum Discussion

Raj27's avatar
Raj27
Occasional Contributor
9 years ago

Write to MS Excel DDT

Set DT_Sheet = DDT.ExcelDriver(InputFilePath,  "XYZ_DT", true)

 

 While Not DT_Sheet.EOF()

 

 DT_Sheet.Value("TestData") = "Test"

 

      DT_Sheet.Next()

 


  Wend


  DDT.CloseDriver(DT_Sheet.Name)

 


I get an error message on line -  DT_Sheet.Value("TestData") = "Test" "wrong number of arguments or invalid property assignments"
 
 
could someone pls hlp how to write value to MS Excel using DDT