TCARREON14
New Contributor
Joined 9 years ago
User Profile
User Widgets
Contributions
Re: TC11 - cannot keep excel open while using DDT.ExcelDriver
We are having the same issue. I did notice that the exact same script works when running our automated scripts on Windows7 64bit with Office 2013, however when we run on Windows10 with Office 2016 we encounter the error you stated. Our script clicks a link that launches Excel then we try to use the ddt.exceldriver to navigate to cell. We get the error you mentioned.1.4KViews0likes0CommentsRe: How do I set project variable (DB table type) by scripting?
Does anyone know if this issue has been resolved yet? is there a link to escalate or promote this so that they can include this in a future release? I am running TC11.33.2298 and am getting a type mismatch error when trying to set the variable. here is a snippet of my code: I am passing over the Variable Name, Variable Type, and the Value. In this case is the path to a CSV file. if varType = "DB Table" then Project.Variables.VariableByName(varName) = "{CSV file: " & varValue & "}" else Project.Variables.VariableByName(varName) = varValue end if2.1KViews0likes0Comments