displaying text elements in seperate workbook

[former_member188325]

Hi all,

When we execute a Query,output will be displayed in sheet1(we have 3sheets…sheet1,sheet2,and sheet3).Our client wanted to see only outout in the sheet1 and remaining all text elemants in the shee2 by default when u excute Query.Is it possible?pl help me.

regards

[Former Member]

After executing a query, you can manually move result area into another sheet: Layout/Move result area. Save a workbook after that. Refresh or a new opening of workbook will leave text elements/header and a result area in separate sheets.

Adding a couple of VBA statements into SAPBEXOnrefresh sub will switch focus automatically into the 2nd sheet with results. So, the user will not have to switch from sheet1 to sheet2.

Best regards,

Eugene

[Former Member]

Hi,

You can do almost what you want: leave text elements box in the sheet1, remove result area into sheet2 and make sheet2 active, so a user will not have to switch into sheet2.

Best regards,

Eugene

[former_member188325]

Hi Engune,

Thanks for u r reply.I dint get u completely.an u pl expalin in detail?how to make sheet2 active?

after that all text elements and output of the Query will be displayed seperately whenever we execute query?

regards