OLE Commands to Duplicate a Sheet
Hi, I would like to know how duplicate a Sheet in excel.
I know only how create a new sheet : xExcelSheetsAdd()
I tried to copy the sheet, create a new sheet, and paste, but it
doesn't work, because Excel display a prompt.
Excel ask if I want to save my copy in clipboard , because the copy is
too important.
Could anyone help me with the correct OLE commands to duplicate a
sheet? An
example program would be great if anyone has one.
Many thanks,
Pierre
|