Can't able to access the data from Microsoft Excel 2016 through TestComplete 11.30 .

[sharathsaru1990]

Hello Sir/Madam,

In our product Microsoft Excel 2016 is recomanded to use. When we are executing our scripts its is failing to access data from MS Excel2016. Where as same scripts are working fine with MS Excel 2013. Please help me on the same.

We are getting an error as

 An Attempt to work with Closed Driver.

Thanks In Advance

Regards

Sharath S 

[Colin_McCrae]

Same error message came up in a thread a couple of days ago.

See if any of the info here helps: https://community.smartbear.com/t5/Functional-Web-Testing/How-to-Use-Excel-file-with-DDT-driver-in-c...

[sanaumar]

Hello, Please check if your Excel is 64 bit, it will not work.

Get your excel back in 32 bit, and run your scripts.

Hope the issue will be resolved.

Best Regards

[Colin_McCrae]

"Hello, Please check if your Excel is 64 bit, it will not work."

Is this a problem with Excel 2016?

I use the 64 bit version of Excel 2010 with TestComplete 11.20 without any problems. (via COM)

[sanaumar]

Hi Colin, This problem is with TC 11.31 and Excel 2013