Forum Discussion

rhsou123's avatar
rhsou123
Contributor
9 years ago

How to use Excel data using DDT driver without keeping the Excel file open ?

Hi all,   I'm using DDT driver to get my Excel data but If my Excel file is closed this doesn't work correctly,   How to solve this please ?   set xlDriver = DDT.ExcelDriver("C:\Script-Resource...
baxatob's avatar
baxatob
Community Hero
9 years ago

In the second case you are passing third parameter as True. This should use ACE Driver instead of ODBC:

 

 

1st case: set xlDriver = DDT.ExcelDriver("C:\Script-
    Resources\BatchRun\myfile.xls","Sheet1",false)

2nd case: set xlDriver1 = DDT.ExcelDriver(C:\Script-
    Resources\BatchRun\myfile2.xls,"BatchRun",True)

 

Why you are doing so? Try to change it to False.

 

rhsou123's avatar
rhsou123
Contributor
9 years ago

it was false for both drivers and just update it to check if it works.

 

Even with two false it is not working.