Report Export To Excel - Set Worksheet Name

(0) Share

Report

Posted on by Samantha73

2,782

Hi All,

I have created a report and I can use "send to" and select excel so it can be saved in excel. Now the question is, is there any way to control the worksheet name once exported to excel?

Currently, it comes up as "Sheet1". We use this excel file as an import file to another external system

Thanks

All responses (1)

Answers (0)

Suggested answer

MahGah 15,437 on at

Like (0)

Report

RE: Report Export To Excel - Set Worksheet Name

Hi

See this post

specially the answer below

Final working solution:

IF ISCLEAR(xlApp) THEN

CREATE(xlApp, FALSE, TRUE);

xlBook:=xlApp.Workbooks.Add;

xlSheet := xlBook.Worksheets.Item('Sheet1');

Code...

xlSheet.Activate();

xlApp.Visible(TRUE);