Merging Different excel Sheets into one sheet

[Ankit]

Hi all

I have one composite datawindow in which i have 5 different
datawindows nested in to it.

I can generate five different Excel sheets for each datawindow ,by
using getchild and saveas function function.

But now i want all the five Excel Sheets to be saved in One single
excel sheet.
So can any one tell the method of merging all the sheets in one

Thanks
Ankit

[olivier]

Do you mean in five worksheets of the same Excel file ?
If i were you i would use OLE.
With a Google search you'll find some example code.

"Ankit" <singha...@yahoo.com> a écrit dans le message news:
3d8e57ff.03110...@posting.google.com...

[Ankit]

Hi

Thanks for your reply

Can you please give the site name from which i can find the code.
And i want to merge all the five different sheets i.e five different
excel files into one excel sheet of one file not five different excel
sheets of one file

Thanks
Ankit

[olivier]

If i had a sample code i would have post it.
If you had no results in your google search you may try forum
sybase.public.powerbuilder.ole-ocx-activex
on NNTP server : forums.sybase.com

"Ankit" <singha...@yahoo.com> a écrit dans le message news:
3d8e57ff.03110...@posting.google.com...

[Ankit]

THANKS Oliver

[olivier]

To tell the truth, in order to use Excel via PB, you need to know a little
VBA.
Here are a few links :
OLE2 Automation to Microsoft EXCEL
http://www.sybase.com/detail?id=44471

Copying Datawindow data to Microsoft Excel using OLE Automation
http://www.sybase.com/detail?id=47867

"Ankit" <singha...@yahoo.com> a écrit dans le message news:
3d8e57ff.03110...@posting.google.com...

> THANKS Oliver