Forum Discussion

rhsou123's avatar
rhsou123
Contributor
9 years ago

Using Excel file with DDT driver in code

Hi, This is my first Testcomplete script and I want to access to Excel file using DDT but I got this error message: " An Attempt to work with Closed Driver"   I verified my Excel, it is 32 bits an...
  • rhsou123's avatar
    rhsou123
    9 years ago

    Thank you !

     

    The problem is solved, I just tried with false instead of true and it works fine.

rhsou123's avatar
rhsou123
Contributor

Thank you !

 

The problem is solved, I just tried with false instead of true and it works fine.

tristaanogre's avatar
tristaanogre
Esteemed Contributor
9 years ago

Ah, that could make a difference as well.  The "true" parameter for the ACE has to do, primarily, with which version of Excel you have installed. True is for versions of excel from Excel 2007 and newer. It has to do with which database driver you wish to use.

Still, you really need to add the CloseDriver call to your code. If you don't, you may get a "max connections" error eventually.

  • rhsou123's avatar
    rhsou123
    Contributor
    9 years ago

    Yes certainly, I already add it.

     

    I'm using Excel 2016 (32 bits).