Forum Discussion
tristaanogre
14 years agoEsteemed Contributor
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?
The help file for DDT.ExcelDriver explains them both.http://smartbear.com/support/viewarticle/11915/ An Excel file contains multiple sheets, typically. So, the "Sheet" parameter is the name of the sheet within the Excel file to use for the data. The ACE driver is a specific driver to allow you to use Excel 2007 files.
On lines 10 and 12 I'll pick itens from one excel file to fill blank quotes. How will I do my loop and how will my lines will be after the code is ready to run?
Write your loop as described above. Your call will look like this for line 10
Cargos.fraCargos.cboCargos.wText = DDT.CurrentDriver.Value("Column 1")Line 12 will read
Call Cargos.fraCargos.txtCBO.Keys(DDT.CurrentDriver.Value("Column 2")) The tutorial that I linked to you before walks you through these kinds of tasks. I'd strongly recommend you read the tutorial and walk through it as it describes these kinds of tasks.