"close" FW_OpenADOExcelSheet()

[Jimmy]

hi,

i use

Code: Select all  Expand view

  objRS := FW_OpenADOExcelSheet( cPathcFile, cSheet, cRange, lHeaders )

to get "ADODB.Recordset" of Excel Sheet

FW_OpenADOExcelSheet() also open "ADODB.Connection"

Code: Select all  Expand view

  if ( oCn := FW_OpenAdoExcelBook( @cFile, lHeaders ) ) == nil

i can "close"

Code: Select all  Expand view

  objRS:Close()

but *.XLSx Files seems to be "Lock" after use FW_OpenADOExcelSheet()

how about "ADODB.Connection" which was called when use FW_OpenAdoExcelBook()

[nageswaragunupudi]

Code: Select all  Expand view

oRs:Close()
oRs:ActiveConnection:Close()

[Jimmy]

hi,

thx for Answer