Thanks, but it still doesn't work for me
I'll try to do more experiments and see if I can have any luck.
Sorry I took so long to update this, was at a customer's site. Anyway, check with the following snippet. I'm using it now and there's no problem with renaming
#STAT = DDE_REQUEST('EXCEL','SYSTEM','SELECTION', $SHEET)
#POS = INDEX($SHEET,'!')
$SHEET = $SHEET(1, (#POS - 1))
$RAW_COTTON_SHEET = $SHEET
#POS2 = INDEX($SHEET,']')
$WORKBOOK = $SHEET(1, (#POS2))
$WORKBOOK_REF = $SHEET(2, (#POS2 - 1))
$RAW_COTTON_NAME = $WORKBOOK + 'Raw Cotton'
$$HIDE_TABS = '[OPTIONS.VIEW(,,,,,,,,,,,,,,FALSE)]'
$$SHOW_TABS = '[OPTIONS.VIEW(,,,,,,,,,,,,,,TRUE)]'
$$RENAME_COTTON = '[WORKBOOK.NAME("' + $RAW_COTTON_SHEET + '","' + $RAW_COTTON_NAME + '")]'
#S = DDE_EXECUTE('EXCEL', $WORKBOOK_REF, $$HIDE_TABS)
#S = DDE_EXECUTE('EXCEL', $WORKBOOK_REF, $$RENAME_COTTON)
#S = DDE_EXECUTE('EXCEL', $WORKBOOK_REF, $$SHOW_TABS)