When ever we open a report in excel, it opens in sheet1 of excel report.
Can we rename this sheet1 to a customized name? If so How?


Thanks
Viswakanth

Yes, we can.

See Excel Worksheet Name topic posted in this forum last december.

Regards,
Mikel

Hi Mikel,

The topic (Excel Worksheet Name) we are looking for is not available. Can you please tell how to customize the sheet name?

Thanks

Antony Gubert.

Use TITLETEXT within your stylesheet -

TABLE FILE CAR
SUM RCOST DCOST
BY COUNTRY
BY CAR
BY MODEL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=REPORT, FONT=ARIAL, TITLETEXT=CAR REPORT, $
ENDSTYLE
END

T

Edited to say -

Well done on using the find facility on Focal Point. You are to be congratulated and it's use encouraged

This message has been edited. Last edited by: Tony A,

Here are the posts you are all looking for:

Excel Worksheet Name

Hope this helps

Also interesting:

Creating Excel Compound Reports

TABLE FILE CAR
  SUM SALES
  BY COUNTRY
  ON TABLE PCHOLD FORMAT EXL2K OPEN
  ON TABLE SET STYLE *
    TYPE=REPORT, TITLETEXT='Country sales', $
END
-RUN

TABLE FILE CAR
  SUM SALES
  BY CAR
  ON TABLE PCHOLD FORMAT EXL2K
  ON TABLE SET STYLE *
    TYPE=REPORT, TITLETEXT='Car sales', $
END
-RUN

TABLE FILE CAR
  SUM SALES
  BY MODEL
  ON TABLE PCHOLD FORMAT EXL2K FORMULA CLOSE
  ON TABLE SET STYLE *
    TYPE=REPORT, TITLETEXT='Model sales', $
END
-RUN

Regards,
Mikel