LPARAMETERS nFunction LOCAL oleApp IF PARAMETERS() = 0 ** For populating data in the sheet nFunction = 2 ENDIF SELECT DISTINCT Table FROM tabledata INTO CURSOR tablenames SELECT('tablenames') nSheet = 1 SCAN ** For renaming sheet name. IF nfunction = 1 WAIT WINDOW "Renaming Sheet" + ALLT(STR(nSheet)) + "..." NOWAIT IF TYPE('OleSheet') <> 'O' ** Get Current Instance olesheet = GETOBJECT('c:\temp\tempsheet.xls') ENDIF oleapp = olesheet.Application with oleapp.worksheets(nSheet) .name = ALLTRIM(TableNa