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()