how to Clear the buffer for a new worksheet

widy

Hello,

Thanks to the informations i created new sheet and it works fine except that there's a little problem!
the first worksheet is ok but not the second one, because i have the first one plus the second....
I cannot use clear nor delete for then i get an empty sheet....
Or i don't know in which correct section do i have to clear the buffer....
Thks for any idea.

widy;

gvolkov

which worksheet? Excel?

widy

:oops: yes ! i did a mistake when posting, i should have posted under the topic "add new sheet" for my request is not much different, i read many users having problems when creating new fonction in Table 370; not me ! thks to all users answering to similar requests i can create many sheet but only the first one is ok... :?

SO i got the first excel correct, with the informations i wanted, but the second one still contains the first plus the second.
CreateSheet does not create a worksheet. It adds data to the existing active sheet....
ok i am not at work but i might have found the answer just here!
viewtopic.php?f=23&t=24087&hilit=add+sheet

MANY THKS
if not mibuso i wonder if i would love navision...
widy,
have a good night & a sweet day.

gvolkov

I developed many many reports that export to excel. Customers love it. And never encountered the problem you describe. Yes, some reports have multiple sheets, and it works as expected.