Forum Discussion
joffre
14 years agoRegular Contributor
Sub CurDriverExample
' Creates a driver
Call DDT.ExcelDriver("C:\MyFile.xls", "Sheet1")
' Iterates through records
While Not DDT.CurrentDriver.EOF
'...
DDT.CurrentDriver.Next()
WEnd
' Closes the driver
DDT.CloseDriver(DDT.CurrentDriver.Name)
End Sub
On my case, I'm using VBScript. I guess the loop will be the same thing:
Aliases.MyApp.MyForm.MyTextBox.Text = DDT.CurrentDriver.Value("MyTextData")I dind't understand before that DDT is a class.
Now, one more doubt. As in the picture attached, what are the parameters that I have to pass to DDT.ExcelDriver!? It requires the path of my ExcelFile, requires a Sheet and 'UseACEDriver'. What is this sheet? And what is ACEDriver?