Forum Discussion

Nitish's avatar
Nitish
Occasional Contributor
9 years ago

How to Use Excel file with DDT driver in code ,without opening the excel file

When I try to access excel with DDT driver ,with Excel file open ,code is working fine , but as soon as I run code the with excel file closed ."An attempt to work with closed driver ".Is there any wo...
Marsha_R's avatar
Marsha_R
Icon for Champion Level 3 rankChampion Level 3
9 years ago

Where in the code does the error show up?

Nitish's avatar
Nitish
Occasional Contributor
9 years ago

FileName = "Path of the file "
intCount = 0
'set Objdriver = DDT.ExcelDriver(FileName , SheetName)
set objdriver = DDT.ExcelDriver(FileName ,SheetName,)//here it shows

' do While not(objdriver.EOF())//here it shows 
' intCount = intCount+1
' objdriver.Next()
' loop

While not(objdriver.EOF())