Report Export To Excel - Set Worksheet Name

(0) Share

Report

Posted on by Samantha73

3,255

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

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

MahGah 15,529 on at

Like (0)

Report

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);

Was this reply helpful? Yes No