Forum Discussion

nancypnp's avatar
nancypnp
Occasional Contributor
11 years ago

DDT.Excel Error 'The Excel workseet "" doesnot exist

Hello, I am working with DDT.Excel and when i am trying to execute following error is shown  'The Excel workseet "" doesnot exist and coded i worte is as below:   Set RefFileDr...
Marsha_R's avatar
Marsha_R
Icon for Champion Level 3 rankChampion Level 3
11 years ago
We had problems moving tests from machine to machine because of the differences in that Users directory.   We ended up creating a directory named Resources on the drive with the TestComplete programs and putting our Excel files there.  This keeps the file name the same no matter where you run the tests.

 


In this case,  your file name becomes


 


RefFileName = Project.Path &"Resources\zxcz.xls"