does anyone know how to rename a worksheet in Excel 97 using DDEEXECUTE() in FoxPro 2.6? The following command works ONLY if you are using Excel 95 and NOT Excel 97:
=DDEEXECUTE(, '[WORKBOOK.NAME(, "")]')
It is assumed that you are on the worksheet you wish to rename before you issue the above command in FoxPro.