DDt driver not working

Question

Hello there, I am facing the problem that

" VBScript runtime error, The Excel worksheet "C://test.xlsx" does not exist" in the below code

Sub TestDriver

Dim Driver

Set Driver = DDT.ExcelDriver("C://test.xlsx", "Sheet1")

RecNo = 0

While Not Driver.EOF()

Call ProcessData()

Call Driver.Next()

WEnd

Call DDT.CloseDriver(Driver)

End Sub

please help me..

Thanks in advance....

karkadil · Answer

Then either use XLS instead of XLSX, or install Data Connectivity Components from herehttp://www.microsoft.com/en-us/download/details.aspx?id=23734

joseph_michaud · Answer

Further information is found inhttp://support.smartbear.com/viewarticle/56928/&nbsp; "Using Excel Files as Data Storages"including the link that Gena references.&nbsp; I just tried it out.&nbsp; Pretty easy.&nbsp; After installing the "2007 Office System Driver: Data Connectivity Components" I no longer got the "Provider cannot be found" message.You will have to change this line fromCall DDT.CloseDriver(Driver)toCall DDT.CloseDriver(Driver.Name)

karkadil · Answer

You must specify the 3rd parameter (true) for the&nbsp;DDT.ExcelDriver method in case of xlsx format.http://support.smartbear.com/viewarticle/55314/

venkaiah_gangav · Answer

When I specify 3rd parameter as 'True', it is showing error as "Provider canont be found.It may not be properly installed"

Forum Discussion

DDt driver not working

Recent Discussions

ID based login only works as admin

I can't map objects of type UIAObject

How to pass in a parameter to DB connection string

Related Content

Fetch the row count in DDT driver

DDT Driver state

DDT Excel Driver in Keyword Test