Excel Automation using multiple worksheets

Dean_Axon

Hi All;

I have searched the forums and found loads of useful information so far, but I still cannot get the required solution (maybe I have been looking at it too long now :shock: )

What I would really like to achieve is to use table 370 (excel buffer) but with multiple worksheets. Sounds easy enough, but its just eluding me. ](*,)

1st question... Has anyone done this already and if so, would they care to share their wisdom? 2nd question... If not, can it be done this way or do I have to write my own functions using the automation servers ? If this IS the case, does anyone have a useful guide to integrating or finding the right commands to push out with office 12 ?

Many Thank in advance

Dean.

Savatage

viewtopic.php?f=23&t=24087

Dean_Axon

Hi Harry,

I had already done something similar to that earlier, but the error that presents itself is this.....

Vendor Table (filtered to 2 vendors for testing)

Vendor - OnAfterGetRecord()
TempExcelBuffer.Addsheet;
TempExcelBuffer.CreateSheet("No.",'XL Heading',COMPANYNAME,USERID);
EnterCell(1,1,"No.",FALSE,FALSE,FALSE,"No.");

This creates the 2 worksheets that I expected ( I had this bit working), but when the "EnterCell" is called, it seems to place the data for the first record onto the second worksheet and completely ignores the second call of "EnterCell" ](*,)

I must be missing something obvious (too many trees, not enough woodland or something along those lines !!!)

TIA.

Dean

Savatage

have you looked at this one?
viewtopic.php?f=14&t=15823

Dean_Axon

figured it out and the link below shows what I did

http://www.mibuso.com/forum/viewtopic.php?f=23&t=24087&p=160108#p160108

Happy Days \:D/

Just want to get rid of Sheet 1 etc. now :whistle:

Ill post once I sort it or link to someone else's idea's on here (I like this sharing concept =D> )

Dean